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