Dear list, If I have a table called acqh which has a column called Desc and I wish to select all the rows that have the word "land" somewhere in the Desc column I can type:
Select * from acqh where Desc like "%Land%" into Selection In the MapBasic window. I am trying to replicate this in MapBasic using a string variable in place of the word Land. I have been experimenting with the Run Command statement but have not been able get it to function correctly. Run Command "Select * From"+acqh+"Where"+Desc+"like"+Acqh_Desc+"Into Selection" (Acqh_Desc is the string variable). Using the code above produces the error message variable or field Desc not defined when the compiled mbx is run and I don't know why. My second problem is how to incorporate the "%%" wildcard element into this statement. Any help or with the two problems above would be really gratefully recieved. Thanks, Rob Brough The National Trust Cornwall Regional Office Lanhydrock Bodmin Cornwall UK. e-mail: [EMAIL PROTECTED] _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
