Thank you! Simon ------------------------------------------------------------------------ -Select expects column and table names, not variables. You must transform variables into "names" before running select, thus
Run command "Select "+satt+" from "+stbl+" order by "+satt+" into uniquetbl" Jacques Paris e-mail [EMAIL PROTECTED] MapBasic-MapInfo support http://www.paris-pc-gis.com ------------------------------------------------------------------------ - Hi, I have this query : Select satt from stbl order by satt into uniquetbl satt refer to the name of the column of the table stbl, satt and stbl are both string variables. Once I run the query, I got a table (uniquetbl) with the same number of record than the original table (stbl) but all the records are empty. If I run the same query by entering directly the name and the field of the table instead of using variables, the result is correct. Can someone help me with this? Thanks Simon --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16090
