Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pessimistic or optimistic row buffering?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00356511
Message ID:
00356548
Vues:
18
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!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform