This may be simple but I can't get MB 6 ( using MI 5.5) to act on the
following


Dim  MySQL as String

MySQL = "Population > 10000"

Select * from MyTable Where MySQL

No errors - it just does not resolve MySQL and the 'where' is ignored




I CAN  put an integer variable in place of 10000

Dim MyVal as integer

MyVal = 100000

Select * from MyTable where population > MyVal





but not for the whole 'where' string.
Now if I wanted to say  change    >  to  =        how would I do it ?


Is this a limitation or am I missing something?


Thanks

Bill




----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to