2018. 09. 02. 17:03 keltezéssel, 'Christian Giesen' chris@...
[firebird-support] írta:

> Good day,
>
> Using Firebird 3.0.3.
>
> RAD Studio 10.2.2 (Tokyo)
>
> I have a need to generate unique sequential invoice/credit note numbers.
> I fully understand the usage of generators to produce unique identifiers
> in tables. However, according to Firebird documentation the use of
> generators does NOT guarantee sequential numbering.

I use and suggest a table instead of generator. More flexible and
transaction controlled solution. If you need more than one (and
independent) sequential number just use same table with more records.

A simple example for it:

https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/128920

Gabor