hi- i was thinking i could use this process. I tried it before it posted and it seems to work.
1) CREATE TABLE table-name newTable based on the modifications the user requests to the existing_table structure found in select sqlite_master.sql from sqlite_master where name = 'existing_table' 2)do an insert of all data from the original table into temporary table 3) drop table existing_table 4) CREATE TABLE existing_table AS select * from newTable is there a better way or is this an ok way to do it?? I found out today that I cant modify sqlite_master.sql or I cant simply issue a new create table statement when the table already exists to change the structure. thanks, marvin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
