Subject Re: [firebird-support] Sequence in Firebird .... nice
Author Woody (TMW)
> Thanks Markus - i was looking for such a procedure - be able to generate
> unbroken serial numbers in invoices. But for now, i juste wan to write
> series of numbers in a column , lets say, from 194 .. 2000. How do i
> generate such a series ?
>

You could set up a temporary generator that starts at whatever number you
want. Use that to generate the numbers you need and then delete the
generator. If you need to do this more than once, you can reset the
generator each time it gets to the maximum number.

Woody (TMW)