Hello Michel, Actually this is not quite right.
For table names, you can substitute a variable and the value of that variable will be used. e.g. dim TabName as string TabName = "world" select * from TabName However for field names, you need to use an alias to get the right results dim FieldName as alias FieldName = "CountryName" select FieldName from world You can construct a SQL select statement in a string and "run command" it but it's often not necessary unless you need to build a complex query - typically with a variable number of fields. Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: Michel Van Asten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 3:36 PM To: [EMAIL PROTECTED]; Ben Crane Subject: RE: MI-L MapBasic Thanks ... it seems to be the solution Michel -----Message d'origine----- De: Ben Crane [mailto:[EMAIL PROTECTED]] Envoye: mardi 3 decembre 2002 15:50 A: Michel Van Asten Objet: Re: MI-L MapBasic Michel use the run command statement... TableName="World" string1 = "Select * From "+Tablename run command string1 produces Select * From World Ben __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4385 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4393
