Subject | Getting a unique value from a generator |
---|---|
Author | Peter Ypenburg |
Post date | 2005-05-12T19:09:27Z |
Hi There,
Is it possible for two users who run the following SQL at the exact same
time (each in their own transaction) to get the same value back from a
generator. The SQL is as follows:
SELECT GEN_ID(EXPORTLOCK_SEQ, -1)
FROM RDB$DATABASE
Thanks.
Peter Ypenburg
AGM: Product Development
Barloworld Optimus
Tel +2711 286 1587 Fax +2711 286 1630 Cell +2782 789 9167
www.barloworldoptimus.com
Disclaimer
The information transmitted is the property of Barloworld Optimus Pty (Ltd)
and is intended only for the person or entity to which it is addressed and
may contain confidential and/or privileged material. Statements and opinions
expressed in this e-mail may not represent those of the company. Any review,
retransmission, dissemination and other use of, or taking of any action in
reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please
contact the sender immediately and delete the material from any computer.
Is it possible for two users who run the following SQL at the exact same
time (each in their own transaction) to get the same value back from a
generator. The SQL is as follows:
SELECT GEN_ID(EXPORTLOCK_SEQ, -1)
FROM RDB$DATABASE
Thanks.
Peter Ypenburg
AGM: Product Development
Barloworld Optimus
Tel +2711 286 1587 Fax +2711 286 1630 Cell +2782 789 9167
www.barloworldoptimus.com
Disclaimer
The information transmitted is the property of Barloworld Optimus Pty (Ltd)
and is intended only for the person or entity to which it is addressed and
may contain confidential and/or privileged material. Statements and opinions
expressed in this e-mail may not represent those of the company. Any review,
retransmission, dissemination and other use of, or taking of any action in
reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please
contact the sender immediately and delete the material from any computer.