Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requiry() and uncommitted changed error
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01260229
Message ID:
01260253
Views:
13
>>
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform