Giles, You need to use a command string: Dim i As Integer i=1000 Select i + 2 From <table> ' ---> "empty" column Run Command "Select " + i + 2 + " From <table>" ' ---> works fine Good luck! Andreas ................................................. Andreas Mahn dds GmbH Stumpfstr.1 76131 Karlsruhe Germany Tel.: +49 - (0)721 - 9651406 Fax: +49 - (0)721 - 9651419 http://www.dds.ptv.de/ ....................... [EMAIL PROTECTED] >---------- >Von: Kennedy, Giles (NMPO3)[SMTP:[EMAIL PROTECTED]] >Gesendet: Montag, 25. Januar 1999 12:19 >An: 'MapInfo-L' >Betreff: MI MB SQL Select: using variables in Select clause > >I'm trying to use a MapBasic variable in a select expression but I can't >seem to get the MapBasic application to pass the value of the variable over >to MapInfo. However it works fine from the MapBasic window. > > ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
