In my app, I use TClientDataSet + TIBOQuery

A common problem is when I put default values in the table using a
trigger (autoinc ID and other default values).

I need to send these values to the client side. In the client side, I
do not know the row ID, so I cannot refresh the record to reload the
new values. In MSQL server I used SCOPE_IDENTITY(), now I see that FB
2.1 has RETURNING clause.

My question is : Using IBObjects, how do I get the ID value after the
TClientDataSet.ApplyUpdates()?


I know that I can use GEN_ID to create the ID in the client side, but
it is not a good idea. I prefer to put all default values in the
server side.

Thank you