Re: how to lock record instead of lock tab?

Karsten Schwarz wrote in message <38993DD1.9252A9B2_at_secco.de>...
>It's simply the same:
>
>select * from table where key_column = value for update.
>
>With the for update clause you will lock all the rows selected.
>
>=8-)
>Karsten

O-o-ps, I thought that SELECT ... FOR UPDATE only locks the last fetched record, but not all the selected records. Am I wrong?

Dmitry. Received on Thu Feb 03 2000 - 04:56:56 CST