Salut Jean-François, You just have to put Quotation mark ( " ). Like: commit table "BDdescriptive_CO" as "BDdescriptive_CO_MI" close table BDdescriptive_CO open table "BDdescriptive_CO_MI" SELECT * FROM Wirecenter,"BDdescriptive_CO_MI" WHERE Wirecenter.sucal = BDdescriptive_CO.clli INTO CO_WC_joint commit table CO_WC_joint As ????????? Hope this help! Bonne programmation!! François Bergeron Conseiller en Géomatique KOREM Inc. ******************************** Hi, I'm trying to save a SQL query between a native MapInfo table and a registered xls table. But when I do, I get an error message saying "No edits pending for table...". Here's the code: ******************************************************************************************************* Register table Applicationdirectory$()+"test_join_co_wc.xls" Type XLS Titles Range "Sheet1!A2:CU1398" Into Applicationdirectory$()+"test_join_co_wc.tab" open table applicationdirectory$()+"test_join_co_wc.tab" As BDdescriptive_CO 'commit table BDdescriptive_CO as BDdescriptive_CO_MI 'close table BDdescriptive_CO 'open table BDdescriptive_CO_MI SELECT * FROM Wirecenter,BDdescriptive_CO WHERE Wirecenter.sucal = BDdescriptive_CO.clli INTO CO_WC_joint commit table CO_WC_joint ******************************************************************************************************* I tried it through MapInfo and encoutered no problem in saving the query. I checked and there is a CO_WC_joint table created following the query, but then I'm not able to save it with MapBasic. Another thing: If I try to issue the command "commit table BDdescriptive_CO as BDdescriptive_CO_MI" (when it's not a comment), I get an error message saying that "variable or field BDdescriptive_CO_MI is not defined". But it's not a variable, it's the name under which I want to save the table!!!!! Those are very simple commands, but something's wrong and I couldn't grasp it. Help me please! Thanks, Jeff Lepine [EMAIL PROTECTED] -- ___________________________________ || // François Bergeron || // Conseiller en Géomatique || // [EMAIL PROTECTED] || \\ || \\ KOREM Inc. || \\ http://www.korem.com Formation MapInfo: http://www.korem.com/formation.html MIG!! www.mig.ca 680, Boul. Charest Est Québec (Québec) CANADA G1K 3J4 ___________________________________ ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
