If you want to close temporary tables, no matter the actual name, use this If-statement instead:

If TableInfo(t, TAB_INFO_TEMP) Then

Regards
Uffe

----- Original Message ----- From: "Tim.Nuteson" <[EMAIL PROTECTED]> To: "John Polasky" <[EMAIL PROTECTED]>; <mapinfo-l@lists.directionsmag.com>
Sent: Thursday, October 20, 2005 12:08 AM
Subject: RE: MI-L Closing Query 'tables'


Hi John,

This will close all query tables in the front mapper:

Include "mapbasic.def"

Declare Sub Main

Sub Main

Dim t as SmallInt

For t = NumTables() to 1 Step -1
If TableInfo(t, TAB_INFO_NAME) like "Query%" Then
Close Table TableInfo(t, TAB_INFO_NAME)
End If
Next

End Sub


-----Original Message-----
From: John Polasky [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 4:15 PM
To: mapinfo-l@lists.directionsmag.com
Subject: MI-L Closing Query 'tables'


Listers-

Is there a 'One-Size-Fits-All' method for closing ALL query/temp tables
in mapbasic, regardless of the query number?

Thanks!!!!

-John


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 18401

Reply via email to