Subject Re: [firebird-support] How to return a IDENTITY field before insert it?
Author Mark Rotteveel
On 2018-02-14 18:59, Omacht AndrĂ¡s aomacht@... [firebird-support]
> Hi!
> Select gen_id(generator_name, 1)) as new_id from rdb$database

You should not do this with the generator of an identity column. The
system sequence to back the identity column is an implementation detail,
and if you have a need to access it like this on a regular basis, then
you probably shouldn't be using an identity column at all.