Subject Re: [firebird-support] Re: Locking columns
Author Olivier Mascia
Paul Schmidt wrote:

>>Should you need to know the id on the client side for anything, you can
>>also proceed this way : first grab the next value from the generator by
>>some SELECT GEN_ID(my_generator, 1) FROM RDB$DATABASE (or any other
>>table for this purpose - that's just a placeholder).
> Make sure the table being used has one and only one record though,
> otherwise you could get multiple ID's one per record, and that would not
> be what you intended.

How could I forget to warn about that ?! :) Thanks Paul.
I even always write a small stored proc just to get the generator value
in order to never be caught by this trap.

Olivier Mascia