Subject Re: [firebird-support] DBKEY or cursor in PSQL
Author Helen Borrie
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
>> 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. :-)