Devart Forums

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?

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.

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