Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lock record in the table
- Thread starter tnerurkar
- Start date
Hi
You need a transaction to do that.
There is support for explicit locking too, but that is also related to transactions : "the lock is dropped as soon as the transaction ends".
Feherke.
You need a transaction to do that.
There is support for explicit locking too, but that is also related to transactions : "the lock is dropped as soon as the transaction ends".
Feherke.
- Thread starter
- #3
Hi,
Thanks for quick reply.
If I do explicit locking even another user can select the record but will not update. I want another user should not select the particular record which I have lock for update.
Please tell me how to do this.
Regards,
Tushar
Thanks for quick reply.
If I do explicit locking even another user can select the record but will not update. I want another user should not select the particular record which I have lock for update.
Please tell me how to do this.
Regards,
Tushar
Hi
That is not possible exactly as you wish. "Row-level locks do not affect data querying". So you have to use [tt]access exclusive[/tt] locking mode.
Feherke.
That is not possible exactly as you wish. "Row-level locks do not affect data querying". So you have to use [tt]access exclusive[/tt] locking mode.
Feherke.
- Status