Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pessimistic or optimistic row buffering?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00356511
Message ID:
00356548
Views:
12
By error do you mean a conflict? User A changes something, User B changes it as well and then wants to save it?

If so, you would use GetFldState(-1, MyAlias) on the record. It will return a string of numbers (ex: 112111) telling you each fields status. From that you decide what to do. If you want to show User B what has changed you can use CurVal() and OldVal() to see what User B has and what is on Disk and then show them to the user.

In the FFC is an example of how to do that in a grid. I don't remember the class name but you should be able to find it in the solutions samples.

hth

>Thanks for answering back. My only question now is if I do use optimistic buffering, and an error occurs, do I use 'on error' to handle the error behind the scenes? Thanks again for your help.
>
>nick patel
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Previous
Reply
Map
View

Click here to load this message in the networking platform