| Subject | Re: [firebird-support] How to return a IDENTITY field before insert it? |
|---|---|
| Author | Omacht András |
| Post date | 2018-02-14T17:59:54Z |
Hi!
Select gen_id(generator_name, 1)) as new_id from rdb$database
Andras
--
Omacht András
-------- Eredeti üzenet --------
Feladó: "Elton Fadel galdarius3@... [firebird-support]" <firebird-support@yahoogroups.com>
Dátum: 2018. 02. 14. 18:56 (GMT+01:00)
Címzett: firebird-support@yahoogroups.com
Tárgy: [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?
How to get it like we did on FB 2.5 with a procedure to get the next ID of a generator?
__________ Information from ESET Mail Security, version of virus signature database 16904 (20180214) __________
The message was checked by ESET Mail Security.
http://www.eset.com
__________ Information from ESET Mail Security, version of virus signature database 16904 (20180214) __________
The message was checked by ESET Mail Security.
http://www.eset.com