From: "Alan McDonald" <alan@...>

>
> what do you mean by "via table row data, no real generators"?
> use generators don't use row data

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.

I generally don't have the amount of traffic competing for those ID numbers
so I don't run into any deadlock problems, although my code handles them if
they do happen. I mainly use the table approach to hold ID's for stuff like
lookup tables where data doesn't change as often. No sense in gunking up the
generator numbers with lots of trivial stuff. :)

Woody (TMW)