Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View definiton has been changed error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00588888
Message ID:
00589079
Vues:
25
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform