Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Multi-User Suggestions
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00411028
Message ID:
00411298
Views:
10
If your using buffering, VFP handles the locking for you. All you have to do is choose a buffering scheme. The most secure is pessimistic buffering, where the first person editing a record gets the lock. However, doing this you run the risk of a person starting an edit, then going to lunch and locking everyone out.

The preferred approach is optimistic locking, where a lock is attempted when you try to commit a change. In this scheme, the lock is only held for the duration of the update. You also run the risk of someone comitting a change while your editing, thus invaliding your edit. In this case you need to implement a conflict resolution scheme. There are examples in the programmers guide.

Charlie
Previous
Reply
Map
View

Click here to load this message in the networking platform