Are you sure you need exclusive locking ? Did you checked the optimistic
approach ? What is the probability to have multiple people editing the same
record at the same time ?
You could also keep a datetime instead of just a bit field. It would allow
to have a safety mecanism so that a long running lock could be discarded...
If you really need you could trap onbeforeunload or onclose or a similar
client side event to call a server side page to unlock the record.
Patrice
--
"Chris" <cc*********@hotmail.com> a écrit dans le message de
news:%2****************@TK2MSFTNGP10.phx.gbl...
Ok what needs to have happen.
when a user edits a record I am locking the record by a bit field.
So if the user clicks the x on that edit screen I need detect that and
unlock the record in the database.
I am storing the locking by user session.sessionID.
If you know of a way to get all session.sessionID's that would work for me
too. I can run a check on that instead. Which is what I want to do.
Thanks
"Chris" <cc*********@hotmail.com> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl... Can anybody tell me how to detect is the user has closed the browser
Thank you