Devart Forums

Posted: **Tue 15 Jul 2008 11:10**

Hello,

I use a ibcQuery and i want to know how i can access to the returning value for the sql below :

update or insert into NOTEFRAIS (ID,Affaire) values('5','test1') returning(id)

Thank you for help

Regards

Posted: **Tue 15 Jul 2008 12:22**

IBDAC creates a parameter with name RET_id for this statement. You can get a returning value with code like the following:

Code: Select all

id := IBCQuery.ParamByName('RET_id').AsInteger;