Peter,
>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.This error happens for views that are
SELECT * FROM ... (a view that has every field in it) and the database has changed the table definition after the view was created. VFP embeds all of the fields inside the DBC for each view and after the change to the table VFP is detecting change and erroring out because the view fields no longer match the tables.
>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.It really sounds like your runtime app is using a different DBC than your dev environment.
>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.To get a view to really change you have to open it in the view designer,
make a change to it and then save it.
>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.