On 26 Sep 2006 at 10:22, james_027 wrote:

>I have a firebird book by helen, but I can't understant the purpose of
>"for update" clause. Can anybody help me explain this?

It turns off result dataset buffering, so client application can be
sure that server cursor in dataset is set to just fetched record.
Used for following UPDATE|DELETE...WHERE CURRENT OF...

--
SY, Dimitry Sibiryakov.