-----Original Message-----
From: Jason L. Wharton [mailto:jwharton@...]
Sent: Thursday, September 20, 2007 3:25 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] RETURNING clause in FB 2.1

> In reality, RETURNING clause is from the FB 2.0, then I understand
> that IBObjects may support it but I cannot find the documentation.
>
> Using RETURNING clause, I expect to return from the server to client
> all columns that the server has altered in the trigger. In this way I
> get 2 improvements:
>
> 1-It is more consistent and safer. The generator name is always the same.
>
> 2-I do not need to call GEN_ID from the client side, increasing the
> network traffic and the source code.
>
> 3-I do not need to call explicitly the TClientDataSet.Refresh function
> to update the row.

I have long been pushing for this capability to be added to Firebird for
exactly the benefits you mention here.

This should be supported just fine in IBO. I recall working on this and so
if you have any troubles with it please let me know.

When the statement is prepared I detect the output parameters and the values
are applied to the columns appropriately.

Jason L Wharton