Lock record

[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.

 

[Robert Dufour]

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

 

[HDI]

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


Robert Dufour schreef:

 

[HDI]

What are the pro's and contra's of optimistic and pessimistic locking?


Robert Dufour schreef: