G'Day Listers,
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.
The error returned (seen below) says that the last created table cannot be
found - ERR_TABLE_NOT_FOUND, however the table exists as can be seen from
the Print statement.
I thought perhaps the table had updates pending, hence my use of the Commit
statement, but still no joy.
I'd love to hear what anyone has to say about what MapInfo is doing with my
table!
intNumTables = NumTables()
If intNumTables > 0 Then
For intI = 1 To intNumTables
strTabName = TableInfo(intI, TAB_INFO_NAME)
Print TableInfo(intI, TAB_INFO_NUM) + " : " + strTabName *
If Left$(strTabName,3) = "tmp" Then
Commit Table strTabName
Close Table strTabName **
End If
Next
End If
* correctly displays (for example)
1 : Roads
2 : tmpTable1 temp tables created
3 : tmpTable2 at beginning of application.
** Error# and description returned - "405:Table 3 not found."
TIA
Christopher Stephen.
winmail.dat
