Howdy, Stranger!

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

Categories

Locking Records

sg123sg123 Member Posts: 11
Hi,

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??

thanks.

Comments

Sign In or Register to comment.