Sorry for the post here - I hit send before looking at the recipient.



In the examples I've received from my customer(s), the InOrderCount is 1.



I will repost in the support forum.



Thanks for the reply Doug!





From: Firebird-general@yahoogroups.com
[mailto:Firebird-general@yahoogroups.com] On Behalf Of Doug Chamberlin
Sent: Wednesday, November 30, 2011 10:21 AM
To: Firebird-general@yahoogroups.com
Subject: Re: [Firebird-general] Generator Question

On 11/30/11 1:04 PM, Kevin Stanton wrote:
> I have a customer that reports from time to time that my application is
> issuing the same Order Number. The order number's source is a generator.

This really should go to the firebird-support mailing list.

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.





[Non-text portions of this message have been removed]