Woody wrote:

> Although I agree that generators are the most error-free methods for
> generating IDs, I also use the method the OP is using for other things. It's
> especially useful when you don't know ahead of time how many counters you
> need and they can be created any time. Generators are limited in number for
> any one database.
>

You can have 32K generators in a database which is a whole lot more than
the number of bigint fields you can have in a table.

Regards,


Ann