returning value

[calou]

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

[Plash]

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;