|
Hello all,
I'm having a little problem with DBMS. I want to link an entire mappable
table from a remote database by selecting all fields in the table, and then save
in MapInfo format.
However, I can't seem to get the server to recognise the * symbol (all
fields). I have tried using both SQL Server and Access, but end up having to
list all columns explicitly in both cases (e.g. "Select IDNum, Col2, Col3,
Col4...., OBJ"). This is a real pain if you have lots of fields in the
table.
The code I'm trying to use is shown below. Can anyone tell me if this is a
recognised problem with DMBS, or if I'm doing something wrong? Will
summarise.
Cheers,
Graham Smith
'*** execute the sqlstatement *** Server connection_number Link Table "Select * From ODBCTablename where (ColumnValue = 'VALID')" Into LinkTable File (dir_temp + "LinkTable") '*** save the linked table as MI table *** Commit table LinkTable as (dir_temp + "MITable.TAB")
|
