Subject | Re: [firebird-support] Re: Firebird 2.0 Release Notes: EXECUTE BLOCK, RETURNING CLAUSE, COMPOUND INDEX |
---|---|
Author | Dmitry Yemanov |
Post date | 2007-07-03T08:35:42Z |
crizoo4712 wrote:
SELECT or EXECUTE PROCEDURE -- you don't specify the INTO part in them
if used in DSQL.
Dmitry
>RTFM doc/sql.extentions/README.execute_block.txt
> YES, I CAN! But what do I have to do here?
> 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 syntaxJust INSERT ... RETURNING <list>.
> and where can I receive the returned values?Set up output SQLDA or host language parameters.
Dmitry