>Hi all...
>How do you update an application without disturbing the data that is actually being used?
>I developed an application for a hobby shop I own. The application is set and running using actual data. I need to do some addings, modifications and stuff. If I bring a copy of the application to my home computer, where I do the developing work,the application will continue to run in the store adding and manipulating more data. What to do after the updating? Is it a matter of copying only the new forms, reports etc or the ones that were modified? I'm not sure about how to proceed here.
>Thanks in advance.
>Ulises

---

Hello,

You can simply copy them. You only have to consider that if you have a new SP that you must renew the VFP6r... DLL's too.
I have made a starter app, which looks at a update dir on the network and replaces my application with the new one. After that it just runs the app.

For the changes in the data structure i've made a datadictionary.
In that dictioary is all the information of the tables fields stored, and a field last updated.
When i have a new data structure i ship the new datadictionary with my update.
when i start my app, it checks the updated fields and applies the changes to the table using ALTER TABLE.

This works great for me.

Hope it helps you too,