Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to lock records in SQL Server
Message
From
03/04/2003 00:55:16
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00772304
Message ID:
00773423
Views:
16
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform