Subject Re: [firebird-support] Re: Firebird 2.0 Release Notes: EXECUTE BLOCK, RETURNING CLAUSE, COMPOUND INDEX
Author Dmitry Yemanov
crizoo4712 wrote:
> YES, I CAN! But what do I have to do here?

RTFM doc/sql.extentions/README.execute_block.txt

> But when it's availale in DSQL, where are the returned values placed?

Into the output DSQL parameters. The RETURNING works the same way as
SELECT or EXECUTE PROCEDURE -- you don't specify the INTO part in them
if used in DSQL.

> What would be the syntax

Just INSERT ... RETURNING <list>.

> and where can I receive the returned values?

Set up output SQLDA or host language parameters.