Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Other user's data entry is appearing in User's entry scr
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00846908
Message ID:
00860215
Views:
15
>In an app I am supporting there is a form that allows users to enter
>tallies. The form has a grid (which holds the tally info), that is buffered
>(optimistic table) and the datasession is private. What is happening is the
>following; user A begins to enter a new tally....user B begins to enter a tally
>and finishes his/her entry BEFORE user A; user B's entry works. When user A
>clicks his/her finish button the tableupdate command fails and his/her entries
>are replaced with user B's entries.

Kimberley, this is a problem that's been around since VFP 3.0. I ran into it myself back then.

The way I ended up resolving it was to edit a temporary cursor, instead of the main table, and then appending all my changes at the end. A local view would also be a possibility here.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform