Lock record

  • Thread starter Thread starter HDI
  • Start date Start date
H

HDI

Hi,


I'm writing a windows application where users can update records but
how can I lock a record when a user opens it.

With ado and vb6 you can lock the opened record but with ado.net I
don't know how to do this.

I am using vb.net and SQL Server.


thx.
 
I agree, I've seen cases where a record was locked when it was opened. The
person going out to lunch, leaving it locked and others who needed access to
it being unable to get it until he/she came back and released the lock.
Not a good idea unless you realy think through and handle all the
unexpected problem scenarios, which is a lot of work.

Regards,
Bob
 
What are the pro's and contra's of optimistic and pessimistic logging?


Robert Dufour schreef:
 
What are the pro's and contra's of optimistic and pessimistic locking?


Robert Dufour schreef:
 
Back
Top