Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to lock records in SQL Server
Message
De
03/04/2003 00:55:16
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00772304
Message ID:
00773423
Vues:
15
>Hmm, i guess we are entering a twilight zone here.
>Your procedure is good when there is little chance of 2 users trying to edit the same record at the same time. When this happens often the following situation can take place:
>The user1 starts editing.
>10 mins passes while user1 drinks coffee and edits a record letter by letter.
>User2 checks the record and sees that more than 10 mins passed and grabs the record.
>User1 tries to save the fruit of his/her labour, looks bluntly at the "Another user just grabbed your record" message and spills the coffee all over the desk in rage.
>
>I would add a timer to the form warning the user1:
>"You have 3 mins to complete the form"

...but, of course
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform