Locking Records


I am looking to be able to lock up a particular row in a table if someone opens it. This may be to update or just to read. They both use the same stored proc to retreive the info.

How can I open the record via my stored proc and make sure that while it is on someones screen, no-one else can open it or at least no-one else can update it???

I have looked at the open pessimistic / optimistic locking mechanisms but I'm not sure how to use them in my situation.

Can anyone help??



Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion