[firebird-support] How to return a IDENTITY field before insert it?

I don't know why identity is better then the old method, but if we can't have access to the next number, this can be useless in some cases. How to get it like we did on FB 2.5 with a procedure to get the next ID of a generator?

Re: [firebird-support] How to return a IDENTITY field before insert it?

Thanks  (: Em Quarta-feira, 14 de Fevereiro de 2018 17:20, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" escreveu:   On 2018-02-14 18:59, Omacht András aoma...@mve.hu [firebird-support] wrote: > Hi! > > Select gen_id(generator_name,

Re: [firebird-support] How to return a IDENTITY field before insert it?

On 2018-02-14 18:32, Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: > I don't know why identity is better then the old method, but if we > can't have access to the next number, this can be useless in some > cases. > How to get it like we did on FB 2.5 with a procedure to get the

Re: [firebird-support] How to return a IDENTITY field before insert it?

On 2018-02-14 18:59, Omacht András aoma...@mve.hu [firebird-support] wrote: > 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

[firebird-support] Android Question

Greets...been awhile since I stopped by... I'm doing some work on Android and want a bit more security that the "none" provided by Sqlite. Is there any way to run Firebird embedded in an App on Android? I'm going to assume without a rooted device (or SYSTEM), a JNI and low-level