Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'View definition has been changed' - HOW???
Message
 
To
20/05/1997 14:57:35
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00032980
Message ID:
00033020
Views:
46
>I am fairly new to views, but have successfully implemented them in several screens. However, one screen is giving me a problem. Page1 of my pageframe has a grid based on a view. All appears fine. Clicking on Page2 seeks the appropriate record in a table (my view is not used for updating) and allows me to edit the record. Clicking back on Page1 issues a REQUERY on my view, which generates the error 'View definition has been changed.' I haven't changed anything (I think), so what does this mean? What could have changed? The view was created using CREATE SQL VIEW MyView AS SELECT .... (without parameters). Any ideas?
>
>Thanks
>Elyse

Elyse, the error isn't really clear. It's trying to tell you that the data in the view no longer matches the data in the tables (because you did the edit on page 2). Put a TableRevert() call before the Requery, and it should be OK

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform