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:
01260234
Views:
14
>Not always, but lately more often, a customer gets the following error:
>
>
>"Table buffer for alias "MyView" Contains uncommitted changes"
>
>
>The error happens on the following line:
>
>
>Requery("MyView")
>
>
>From the screen shot of the application window it looks like the application is in the idle mode (not changes are being done). Is it possible that the error is cause by the fact that another application accessing the data and making changes to the table of the view?

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)
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