Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ado/sql - locking

Author  Topic 

99miles
Starting Member

7 Posts

Posted - 2002-04-28 : 23:23:38
So, I'm trying to grasp the concepts of locking and transactions.
I have read documents all over the web and can't find an example or the answer to what I want to do.
I want to edit fields of a database (one row at a time) in a web form. When a page is being viewed in edit mode, I don't want anyone else to be able to edit it.
So, I guess I want to lock the field when the edit form comes up.
How, and where do I specify that I want row-locking???
Then, how do I check if the file is locked when another user requests to edit that row?
Thanks so much for any suggestions or direction. A simple example would be the most helpful, otherwise hopefully a description will get me started.
-Mac

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-28 : 23:51:18
Do not cross post.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15380

Go to Top of Page
   

- Advertisement -