Devart Forums

Posted: **Thu 18 Feb 2010 23:29**

How can I retrieve the value from a statement like this:

INSERT INTO INVOICE(dtStatement)
VALUES('01/31/2010')
RETURNING ID

I am using a TSQLQuery to execute the statement from Delphi 2006 on a Firebird 2.1 database.

Thank you for your help.

Jack

Posted: **Tue 23 Feb 2010 10:41**

To solve the problem you should add a new parameter to TSQLQuery with Name = 'ID' and ParamType = ptOutput. After this you can get ID value using the code:

Code: Select all

ID := SQLQuery.ParamByName('ID').Value;

Posted: **Thu 25 Feb 2010 16:06**

This works perfectly. Thanks.

Devart Forums

INSERT RETURNING

INSERT RETURNING