| Subject | Re: [Firebird-general] Generator Question |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2011-11-30T18:21:02Z |
On 11/30/11 1:04 PM, Kevin Stanton wrote:
I suspect the use of :InOrderCount may be causing problems. AFAIR, this
param should always be 1 if you want steadily increasing order numbers.
If it was always 1 you might see some skipped values (due to other logic
errors) but you should never see a duplicate unless you purposefully
reset the generator's value.
> I have a customer that reports from time to time that my application isThis really should go to the firebird-support mailing list.
> issuing the same Order Number. The order number's source is a generator.
I suspect the use of :InOrderCount may be causing problems. AFAIR, this
param should always be 1 if you want steadily increasing order numbers.
If it was always 1 you might see some skipped values (due to other logic
errors) but you should never see a duplicate unless you purposefully
reset the generator's value.