Hi all,
I am trying to update one temporary column. I am thinking, if I can delete
that column and add new column, then I will get my job done. However, what
I found from the reference book is: alter table cannot be used on linked
tables. I can't use Update Statement either, as I need to get the value from
the linked tables and update statement doesn't seem to support that (if I
miss that, please let me know.)
This is the code I use to add the temp column:
Add Column LayerName (POP Float)From table1 Set To POP Where COL1 = COL1
Dynamic
Here is what I am trying to do:
for i = 1 to NumCols(LayerName)
strCol = ColumnInfo(LayerName, "COL" + i, Col_Info_Name)
if Instr(1, strCol, "POP" ) > 0 then
lgCheck = Ask ("Do you want to overwrite the existing column?", "Yes", "No")
if (lgCheck) then
Alter Table LayerName (Drop Pop) '***THIS DOESN'T WORK
else
exit sub
end if
end if
next
Any suggestions are highly appreciated!
TIA,
ShuHua
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.