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.
| Author |
Topic |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2002-03-07 : 05:53:40
|
| Hi,I am using ASp and SQL Server for my site.Suppose one admin user is editing the Member details in administration module, then the other logged in admin user should not edit the same member.Is it possible?Can i lock that record?Thanx in Advance---------------------------Sandesh - The Messanger |
|
|
Nazim
A custom title
1408 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-03-07 : 11:01:29
|
| Not without holding an open transaction which is not a good idea.You can get the first to call a read for update stored procedure. This can put an entry in a table giving the spid (or user info) and record id.If another wants to edit then the SP can check the table to see if the record is taken and the user still logged in and reject the request.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-03-08 : 01:16:45
|
Thanx nr and Nazim,Will try your solution....if stuck up with any problem then will expect some time from you..... ---------------------------Sandesh - The Messanger |
|
|
|
|
|
|
Want to lock the record.