Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View definition has been changed. - Ouch!!!
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View definition has been changed. - Ouch!!!
Miscellaneous
Thread ID:
00265552
Message ID:
00265552
Views:
56
We have a form with several views that are loaded in the DE. They all load great. On the form, we have a grid with the control source being one of the loaded views. In the DE and Properites of the view called SCHED1, we have nodataonload=.F. When you start the form, the SCHED1 view is loaded with data and is displayed in the grid. The view has a couple parameters, begindate,enddate. For some reason, (this has been working for a long time) now if we tab through the begindate and enddate fields, the following code is run:

=requery('sched1')
thisform.SchGrid.Refresh()

Now when the =requery('sched1') is run, we get the following error message:

View definition has been changed. If I ignore the question the requery doesn't happen. In the command window I can also open the view and =requery() and it works. I can run a report based on the view, and it works. I can browse the view and it works. What is happening. This is done in VFP6 with SP3 installed.

There have been 0 changes to the base record.
Next
Reply
Map
View

Click here to load this message in the networking platform