Hi All,
Simple question for Monday, can you use a variable as the column name in a SELECT command? If so how?
I have tried:
SELECT * FROM sTABLE WHERE sLC Like sLV INTO sLT NoSelect
And my resulting table is empty, but when I run
sSQL = "SELECT * FROM " & sTABLE & " WHERE " & sLC & " Like """ & sLV & """ INTO " & sLT & " NoSelect"
Run Command sSQL
My resulting table has the correct data.
The first method doesn't create any error messages, it just doesn't work.
Any Ideas???
Cheers Ian
Ian Tidy
GIS Administrator
Works Asset Department
Napier City Council
Hastings St, Private Bag 6010, Napier, New Zealand
Phone +64-6-835-7579 Ext. 8115
Fax +64-6-835-7574
mailto:[EMAIL PROTECTED]
http://www.napier.govt.nz
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
