Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1494/View definition has been changed
Message
From
15/07/1999 20:05:58
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00241933
Message ID:
00242085
Views:
22
>Does anyone have some insight into what may be the cause of this error?
>
>The help file says:
> View definition has been changed (Error 1494)
> The view cannot be re-queried.
>
>· The view definition in the database has been changed.
>
> Close and reopen the view. To ensure that the view is not
> changed, open the database exclusively.
>
>I am trying to requery a local view. The local view has not been changed. The local view is based on a remote view that has been changed. Where I am confused is that I have other forms doing the same thing and I cannot see any difference.
>
>
>Steve Smith

If you ever have a view based on a view, this kind of thing is possible. When VFP queries a view, it samples the data in the first few records to determine the width of the fields. If your base view was queried, and the columns widths came out to one number, and the seconds view (based on the first) was queried, then the fist requeried and the columns widths changed, the second would throw this error. Can you give the SQL that defines both views?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform