Pessimistic concurrency question

  • Thread starter Thread starter k3
  • Start date Start date
K

k3

Hi,

If I lock a record once I retrieve it for editing during a transaction, what
will happen if another client queries for the same record? Will it allow a
read-only record or will it return an error stating that the record cannot
be opened? I'm looking at changing records where it is essential that no one
else makes changes while a record is out for editing by the first person who
retrieved it.

Thanks
 
Depending on the type of lock you create, others trying to read the row will
suceed, but will get a timeout exception if they attempt to change the row.
There are lots of other factors as well. See my article at
http://www.betav.com/pinnacle.htm.

hth

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top