Re: MI MB:Close Table statement fails...

[Warren Vick, Europa Technologies Ltd.]

Hello Chris,

> Below is a small bit of MB that is frustratingly failing.
> Having created two temporary tables and then inserted values into them, all
> I want to do is close them (and discard the updates) at the end of my
> process.
> [Snip]

When your loop closes a table on which the temporary table were formed, they are 
automatically 
closed. This means a single "close table" statement actually closes more than one 
table.

Try running through your loop just to do the "commit"s and then close everything with 
"close all". 
Alternatively, if you want to keep the structure of your code the same, you could 
change it to the 
following. It treats the list of open table like a queue [line] and takes the next in 
line until there are 
none left.

' Typed in ad hoc. May not compile but I am sure you get the idea!
While NumTables()
   strTabName = TableInfo(1, TAB_INFO_NAME)     ' Always use the first table
   Print TableInfo(intI, TAB_INFO_NUM) + " : " + strTabName *
   If Left$(strTabName,3) = "tmp" Then
      Commit Table strTabName
      Close Table strTabName **
   End If
Wend

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]