Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is this a BUG
Message
 
 
À
21/02/1999 13:39:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00189702
Message ID:
00189822
Vues:
8
>>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.

Never thought about that one. Maybe padr(alltrim(somefield), 40, " ") would keep the field at a reliable width of 40 or whatever number you select, thus avoiding the problem?
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform