Hi Pavel,

Sorry I meant for the SQL to be:
SELECT GEN_ID(EXPORTLOCK_SEQ, 1) FROM RDB$DATABASE

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



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links