>>I periodically ship updates to my systems to the field. These updates can contain structural changes to the tables. In the past (foxpro2.6 Dos) I stored the new updated (empty) tables in an update directory. I then renamed the existing (full of data) files, copied the update table to the active directory and performed an append from to get the existing data into the new table format. VFP5 and its database (DBC) has roadblocked me from doing this.
>>
>>How do the rest of you handle updates in the field?
>>
>>Thanks in advance
>>
>>Terry
>
>Check out Stonefield's Database toolkit. www.stonefield.com
Thanks Eric
I am trying their demo now. I am very attracted to the idea of Update() as I don't need to check the versions of the existing client tables like the ALTER TABLE method would require. Handling updates as a sort of repair concept is interesting.

Thanks

Terry