Hi ,
I'm trying to do the following [this works fine in VFP]
semaphore table contains (tablename, id, username)
If user wants to edit a particular order say,
I look for the tablename+id in the semaphore table.
If found I try to rlock it (in case previous user crashed etc) if I can rlock it then user can edit it.
if not found then add record + rlock() it...
I was hoping I would be able to write a SP to do the above and return true if successful.
This is the only way I can think of to implement a pessimistic locking strategy...
Regards
Kal
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement