Subject Re: [IBO] RETURNING clause in FB 2.1
Author kokok_kokok
Helen, thank you fore your response. I am working on a new version of
my application and it will released in 1 year, now it is not for
production work.

Secondly, sorry for my english. Now, I am using GEN_ID in the client
side, effectively it calls the database to get the ID, then I assign
the ID to the record and finally I call ApplyUpdates to send the row
from the client side to the server side. In this way, I know the ID in
the client side and I can refresh the record to see the default values
assigned by the trigger after ApplyUpdates.
However, I prefer to assign the ID in the trigger for the following
reason: It is safer and consistent because it would use always the
same generator name. In the client side, I can use different
generators for mistake (I have different programs acceding to the same
database and I can do errors, using other generator names)

In any case, the current model (calling GEN_ID from the client) works
fine.

Thank you