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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
