At 06:35 PM 5/12/2008, Dmitry Y wrote:

>tion anyway.
>
>True, although WHERE CURRENT OF saves you a couple of page fetches per
>row as compared with the DBKEY based update.
>
>> The old syntax (pre Fb 2)
>>
>> for select FOO from YAK
>> FOR UPDATE
>> into :var_foo, :var_yak
>> AS CURSOR aCursor
>> do begin
>> <do some work>
>> update YAK set Foo=:var_work
>> where current of aCursor ;
>> end
>
>I wouldn't call it "old", as it's perfectly valid and supported in all
>FB versions :-)

I didn't mean to imply it was "old and dead", only that it's been around for a long time (like me, really...); specifically, well before the new shiny Fb 2 syntax arrived. :-)

./heLen