I keep getting the error message 'Base table fields have been changed and no longer match view fields. View field properties cannot be set' when I launch various screens in my application. This appears to be happening for about 6 different remote views out of the 55 that are in this database.

The views do match the base tables. These screens have worked before and this just started happening about 2 weeks ago. When I modify the views within VFP's project manager I do not get this error message. The weird thing is that if I modify the view, save it and run the app from VFP's command window I do not get this error message. But if I exit out of VFP, start it back up again and run the app it happens again.

I have tried the following with no luck.
Deleting the view and recreating it. No luck.
I validated, cleaned up and removed deleted records from the database. No luck.
I even deleted the database from the project/deleting the files. And recreated it and the views again. No luck.
I thought it might be the data type casting of the fields in the view so I
I even tried removing all fields from the view except for the primary key field 'addressid' and still got the same error message when I launched the screen.

I also tried creating the exact same view and giving it a different name.
When I ran that it worked but I really do not want to go through my entire app and change all code and controlsource properties that reference 'vwrclientaddress' to 'vwrclientsaddress'.
Plus like I said this is happening for a few other views so it would require many changes.


This app is being built using VFP version 6.0 and SQL Server 7.0.

I welcome any ideas or things to try.

Thanks,
Peter Chmiel