Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lock
Message
From
17/09/2002 17:12:28
 
General information
Forum:
Visual FoxPro
Category:
CodeMine
Title:
Re: Lock
Miscellaneous
Thread ID:
00701397
Message ID:
00701521
Views:
16
>So, I see I can tell them what's been changed.

Correct.

>That sounds good enough. Do you have a pill I can take to absorb that knowledge instantly ?

Haha. No, sorry. No pill available. However, the trick is to use functions like Curval() and Oldval() on the record(s) where contention has occured. With these functions, you can loop through the fields in the affected record and look at the difference in the returned values. To use these functions, optimistic row or table buffering must be in effect. Then, you can display a dialog/form for the user which tells them what the value originally was when their version of the cursor was buffered, what the value is that has been subsequently written back to the data source by the other user, and where appropriate, what the value is that the current user has changed to. So, there are potentially three different values for any given column :- 1) What the value was originally for the current user; 2) what they have changed it to now (before saving the reord); 3) what another user has changed it to between the current users action of loading the record but before the record is saved back to the data source. I hope I have made this bit clear enough.

HTH

Best
-=Gary
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform