Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

Different kind of cursors

19 views
Skip to first unread message

Dimitry Sibiryakov

unread,
Jul 21, 2024, 5:21:27 AM7/21/24
to firebird...@googlegroups.com
Hello All,

are PSQL cursor and DSQL cursor supposed to cooperate?

I'm trying to perform following block and it fails:

execute block as
declare variable dummy integer;
begin
for select a from x for update into dummy as cursor abc do
begin
execute statement 'update x set b = b + 1 where current of abc';
end
end

Error is:

-Invalid cursor reference
-Cursor ABC is not found in the current context

--
WBR, SD.
Reply all
Reply to author
Forward
0 new messages