Subject | Re: [firebird-support] Getting a unique value from a generator |
---|---|
Author | Pavel Menshchikov |
Post date | 2005-05-12T19:33:09Z |
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
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