Re: select for update ???

From: Steve B <steve.bright_at_capgemini.co.uk>
Date: Tue, 14 Sep 1999 10:23:06 +0100
Message-ID: <7rl45t$loc$1@taliesin.netcom.net.uk>

It locks all records that are returned by the select statement.......the lock is released by a commit.

Its good to use when you want to work with a particular record(s) for a period of time and must ensure that no other user can update the record at the same time...

Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Christian Bruno wrote in message <7rl2cg$dob$1_at_minus.oleane.net>...
>could someone tell me what SELECT FOR UPDATE implies ?
>it locks all records ?
>
>thanks a lot,
>Christian
>
>
Received on Tue Sep 14 1999 - 04:23:06 CDT