Hi folks,
I am upsizing a system from VFP to SQL Server and want to carry on using semaphore locking. In VFP I could do something like
IF semaphorelock("tablename", id)
*-- ok
This would add a new record to the table for the tablename/id combination (if it didn't exist) and also RLOCK() it at the same time (in case user crashes).
However whilst I know I could write a stored proc to do the writing to table etc I'm not really sure how to explicitly do a RLOCK in SQL Server. From what I've read SQL Server seems to perform a dynamic lock i.e. it determines itself whether the table should be page locked etc.
Any ideas ?
Kal
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