Subject Re: [firebird-support] Get current value from generator
Author Ann W. Harrison
Mark Deibert wrote:
> I know you can use GEN_ID(gen_name,1) to get the next value. How can I get
> the current value without incrementing it? Can I do (gen_name,0)?
>
Yes but remember that generators are not transaction based. If some
other request increments the generator, you won't get the value you just
stored.

Regards,


Ann