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 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.

Mark
  • [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