Subject Re: [firebird-support] Getting a unique value from a generator
Author Pavel Menshchikov
Hello Peter,

PY> Is it possible for two users who run the following SQL at the exact same
PY> time (each in their own transaction) to get the same value back from a
PY> generator. The SQL is as follows:

PY> SELECT GEN_ID(EXPORTLOCK_SEQ, -1)
PY> FROM RDB$DATABASE
No, it's impossible if you use -1 (or another negative value, in your
case) as a step in all your queries.


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com