Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Lock
Message
De
17/09/2002 17:12:28
 
Information générale
Forum:
Visual FoxPro
Catégorie:
CodeMine
Titre:
Re: Lock
Divers
Thread ID:
00701397
Message ID:
00701521
Vues:
17
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform