Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View definiton has been changed error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00588888
Message ID:
00589079
Views:
24
This message has been marked as a message which has helped to the initial question of the thread.
>I don't think so. I've been using it in a bunch of similar views without a problem.
>
>>>
>>>If I put it in the DE of a form I get a "View definiton has been changed" error when it is requeried. If I remove the following from the view it works fine:
************
The only time I have seen this error is with calculated fields. The problem is that the first time you use the view, the field length (if it is a character) is set. If requery() and the value of that field is a different length then you get this error. The answer (for me) has been to absolutely fix the length of the field. Use PADR() PADL() LEFT(ALLTRIM(x)+SPACE(y),z) or some function like that to eleminate the posibility of the field being different when you requery and get a different record. You need to adjust this solution for your specific calculated field.
Dr. Ken A. McGinnis
Healthcare software design
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform