Re: how to lock record instead of lock tab?

Select ... for update will lock all selected records until the transaction ends. Try it.

Karsten

Dmitry Sirotkin schrieb:

> 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 - 05:58:41 CST