Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Requiry() and uncommitted changed error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01260229
Message ID:
01260253
Vues:
14
>>
>>No, most likely you programmaticaly change the value of some control after it is binded to the cursor field.
>>
>>Just for debug:
>>pre>
>>lcStr = GETFLDSTATE(-1,[MyView])
>>WAIT WINDOW lcStr
>>Requery("MyView")
>>
>>
>>And you will see what field has been changed (if any in the current record)
>
>Please, just to clarify, you are saying that a value in the cursor view (MyView) is being changed? And not the value of the table field corresponding to the view field, correct?

Yes, you have changes in your View, not in the underlaying Table.

>
>The reason I am asking is that recently this customer developed his own program (I am not ever sure he used VFP - I think he used Java) and his program adds records to the table on which my view (MyView) is based. So I was wondering if it is possible that by him adding or changing values in the VFP table it could affect the =requery() of my view.

If somebody changes your table before you run TABLEUPDATE() you will get different error. TABLEUPDATE() will return .f. and AERROR() will return that there are collisions, of course if you didn't force the TABLEUPDATE(1, .t.,...)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform