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
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
Previous Topic: Saving into two tables
Next Topic: Help : Date calculation
Goto Forum:
  


Current Time: Thu Mar 28 07:40:25 CDT 2024