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?
Firebird EXECUTE BLOCK RETURNING CURSOR
Re: Firebird EXECUTE BLOCK RETURNING CURSOR
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.
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.
Re: Firebird EXECUTE BLOCK RETURNING CURSOR
Firebird does not allow returning output parameters "EXECUTE BLOCK" without calling SUSPEND: https://firebirdsql.org/file/documentat ... ock-params