Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View definition has been changed, but I didn't change it
Message
From
02/11/2000 14:58:33
 
 
To
02/11/2000 11:38:18
Rex Mahel
Realm Software, Llc
Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00437164
Message ID:
00437305
Views:
20
>All
>
>I have a complicated view I create in code. When I requery this view I get:
>
>View definition has been changed.
>

This is almost always caused by an ALLTRIM() in the view definition, or a call to some other function that can cause the results to contain fields of variable length. What happens is the that first call defines the structure of the view cursor with the results. If subsequent calls return data that is ALLTRIM()ed (or whatever) to a different length, you get this error.

Another common reason for this is a view based on a view, but I don't think this applies to you...
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform