Re: MI-L Drop and replace all columns? - then Rename Table

[Ross Nixon]

RE: MI-L Drop and replace all columns?Ross,

Alternatively, you could do it this way:
create a new table with the new columns
make it mappable so it can hold geographic objects
Insert objects from old_tablename into new_table
delete the old_tablename

Create Table "new_table" (ID Integer,Field1 Integer,Field2 Integer) file
"C:\Temp\new_table.TAB" TYPE NATIVE Charset "WindowsLatin1"
Create Map For new_table     'Using Old_tablename ***removed as USING is not
valid in version 6.5
Insert into new_table (obj) select obj from old_tablename
Drop Table old_tablename

Greg Driver.
----------------------------------------------------------------------------

Thanks Greg, I've gone for that method.

One problem:    I am looping through many tables and want to rename the
new_table to old_tablename
after each Drop Table.

I have tried variations of these:
    Rename Table new_Table As Old_tablename
    Rename Table new_Table As str$(Old_tablename) + ".tab"
but get error "variable or field *actual_Old_tablename in here* not
defined".

So my old tablename is getting in there, so how is it not defined?
I defined it early in my Loop,
    Old_tablename=TableInfo(snLoop, TAB_INFO_NAME)

Thanks,
Ross


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16877