Firebird EXECUTE BLOCK RETURNING CURSOR

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jynghyun
Posts: 4
Joined: Mon 24 Sep 2018 01:11

Firebird EXECUTE BLOCK RETURNING CURSOR

Post by jynghyun » Mon 24 Sep 2018 01:17

I'm creating EXECUTE BLOCK statement which returns cursor.

UniQuery1.SQL.Text := '..block statement..';
UniQuery1.Open;

But UniQuery does not work with the statement. The statement is tested in public fb manager and works well.

Can you help me?

jynghyun
Posts: 4
Joined: Mon 24 Sep 2018 01:11

Re: Firebird EXECUTE BLOCK RETURNING CURSOR

Post by jynghyun » Mon 24 Sep 2018 10:34

I found It is because I used "?" instead ":" for parameter.

One more question.

Can you some code to get Return value of "Execute block statement" without using suspend?

i.e I just execsql and read return value as params.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Firebird EXECUTE BLOCK RETURNING CURSOR

Post by ViktorV » Tue 25 Sep 2018 08:42

Firebird does not allow returning output parameters "EXECUTE BLOCK" without calling SUSPEND: https://firebirdsql.org/file/documentat ... ock-params

Post Reply