From: "Artur Anjos" <arsoft@...>

>
> I just want to remember everybody that the discussion 'auditable series'

is

> out off this topic. ;)
>

I agree. A serial generator is a whole different animal than a number
generator. I haven't read Jason's insight into it but I have a few ideas
about the problems you can have.

But, I've gotten used to providing a generator for almost all master tables
even if they have another, user-directed field like order numbers. This
keeps me from having to later go in and change things when they start
re-using the numbers even though they claim they never would. <g>

I base all keys on the generator value and the order number and that
generally suffices, especially for past history. It would be great to have
an automatic field that could be defined. I wouldn't even be opposed to
calling it AUTOINT or AUTOINT64 just in case. <g> It's simple and concise
and I think it explains it easy enough.

Woody
My mind works like lightning. One brilliant flash and it is gone.