Hi!

Select gen_id(generator_name, 1)) as new_id from rdb$database

Andras

--
Omacht András


-------- Eredeti üzenet --------
Feladó: "Elton Fadel galdari...@yahoo.com.br [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?




__________ 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

  • [firebi... Elton Fadel galdari...@yahoo.com.br [firebird-support]
    • Re... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
    • Re... Omacht András aoma...@mve.hu [firebird-support]
      • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
        • ... Elton Fadel galdari...@yahoo.com.br [firebird-support]
          • ... Arnaldo Caliari arnaldo.cali...@studiosoft.info [firebird-support]
            • ... Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]
            • ... Helen Borrie hele...@iinet.net.au [firebird-support]
              • ... Arnaldo Caliari arnaldo.cali...@studiosoft.info [firebird-support]
              • ... Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
              • ... hv...@users.sourceforge.net [firebird-support]
                • ... Ann Harrison aharri...@ibphoenix.com [firebird-support]

Reply via email to