Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to lock records in SQL Server
Message
 
 
À
02/04/2003 01:20:43
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:
00772914
Vues:
20
>In a stateless environment, we use something similar. But, we add another field. Additionaly to one field which is identifying who is having priority to update a record, we also add another field which is an expiration. So, within that timeframe, if the update has not been done, someone else can take over the record. So, on the Web, we usually offer 10 minutes for the save to be done. Depending on the need, this can be greater. After that, if no save is done, someone else can take over it. If no one takes over it, if the main person saves at 12 minutes, it'll work.

Hi Michel.
A similar idea came to me before reading your message. Only i would use only one datetime column which would register the time the user1 began editing. If another user - user2 sees that more that 10 mins passed between the datetime and the now then it means that user1 did not complete editing. The user interface is equipped with the 10 min expiration timer.
Your method adds a conveniance of knowing who was the last user with intention to edit/add a record.
Best wishes.
Kamil
A moment of silence is our cosmic reset button.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform