Home » RDBMS Server » Server Administration » Simultaneous select and update while row-locking?
Simultaneous select and update while row-locking? [message #370628] Tue, 11 January 2000 18:09 Go to next message
Paolo Valladolid
Messages: 1
Registered: January 2000
Junior Member
Hi,

I want to be able to select some rows, lock them (as in "select for update"), and update the rows before releasing the lock.

How do I do this? I cannot find any examples.

Thanks,
Paolo Valladolid

Report message to a moderator

Re: Simultaneous select and update while row-locking? [message #370633 is a reply to message #370628] Wed, 12 January 2000 04:22 Go to previous message
Amit Chauhan
Messages: 74
Registered: July 1999
Member
Hi,
I dont get it what exactly you want as this is what happens when locking a row. When you try to update any row, you first lock it using SELECT FOR UPDATE, then update the row and then save it and this then releases the lock.

Amit

Report message to a moderator

Previous Topic: Saving into two tables
Next Topic: Help : Date calculation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 11 06:02:17 CDT 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.