Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this a BUG
Message
From
21/02/1999 13:39:38
 
 
To
20/02/1999 17:35:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00189702
Message ID:
00189808
Views:
10
>I am using a Grid with data from a view. After using the requery() for 2 to 3 times I receive a message 'View definition has been changed'. I use the view only to retrive the information. I am using VF 5.0a.
>
>Thanks for help

Eduardo-
Can oyu post the code that defines your view? Most often, this error occurs from and ALLTRIM() in the view definition, or the view is based on another view or cursor, whose structure has changed. The reason this happens (with ALLTRIM()) for example, is that the first time the view is queried, VFP looked at the widths of the fields in the resultss of the query to decide how long the view results cursor fields needed to be. THen the next time the view was queried, different records were pulled in, possibly whose shortest length was different than the shortest one the last time the view was queried. The same thing goes for views that are based on other views- the required field length changed.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform