I am using VFP6. I have a stand-alone remote application on which I need to change the definition of a field and add a field to a table in the DBC. How can I do that programmatically? I have thought of two ways:

1 - Create a new table with the changes and add it to the dbc. Then append the data from the old table and populate the new field as appropriate. Drop the old table. Copy the data from the new table to the old table. Drop the new table. However, this seems very crude and I don't know how to capture and then recreate the persistant relationships etc.

2 - Create a mirror dbc with all tables (empty). Move the old dbc and tables into another folder and the new dbc into the proper folder. Capture the table names from the new dbc into an array. Open the new dbc and moving thru the array, append the data from the tables of old dbc in the other folder. Delete the old dbc and tables. This retains the relationships but it also seems crude manipulating all the data in the other tables that don't need adjustment.

If I had PCAnywhere I could do it from my location, but I don't. I must do it programmatically or talk the user thru the steps on the phone.

Any suggestions?

Glen Mettler