>Then point the DBC to the new tablename when it asks to locate it.
Is it possible to do this without user intervention? This should be in a standard upgrade procedure.
The purpose is to upgrade entire tables by adding a new (temporary) table to the DBC, appending from the original table, then removing the original and renaming the new table.
To remove the original table first would be dangerous if for any reason the upgrade procedure has been interrupted.
Which is the best way to upgrade tables that are included in the DBC, without any danger of data loss?
The Alter table command would be much more code intensive, and if a table got upgraded only partly (only some one of the new fields got added) this would be very difficult to track. By replacing the entire table this is much more secure, as we did with FoxPro 2.6
Any ideas for this to do in a better way?
Christian Isberner
Software Consultant