Interesting quirk in MapInfo's SQL parser. Whilst tracking down a bug in some code I found an apparently invalid SQL statement with 2 "where" clauses. To my surprise, the statement compiles and runs - it also runs in the MapBasic window - and produces the expected query result. The statement is similar to that below:
Select Col1 from <table> where Col1 < 100 where Col1>1 into selTest NoSelect However, if you try and close the temp table, MapInfo tells you "Cannot perform this operation on table selTest". The temp table is then closed. Anyone know if 2 "where" conditions are legal in SQL ? Best Regards, Martin Higham Avantra Geosystems ph (61 3) 8504 0428 0425-730-428 fx (61 3) 9596 7997 www.avantra.com.au --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3382
