This is a problem that is driving both me and my customers crazy. I have tried various things to fix it but haven't come up with a solution yet and need some help.
We are running VFP7 on SQL2K machine and occasionally, though not often, it will give an error saying "Base table fields have been changed and no longer match view fields." This is a complete load as the tables in SQL have not changed. The only time any table changes occur is during occasional updates. We then have the users delete their current database container with the views and the software will automatically rebuild them. Something that works fine on one pass will suddenly stop working the next time the form is opened.
HELP!!!!!!!!!!!!!!!!
We are running VFP7 on SQL2K machine and occasionally, though not often, it will give an error saying "Base table fields have been changed and no longer match view fields." This is a complete load as the tables in SQL have not changed. The only time any table changes occur is during occasional updates. We then have the users delete their current database container with the views and the software will automatically rebuild them. Something that works fine on one pass will suddenly stop working the next time the form is opened.
HELP!!!!!!!!!!!!!!!!