> > > As for a true series type Auto incrementing field, that would be
> > > nice, but should probably be implemented as a serial generator,
> > > that is a generator that guarantees there are no holes in the series,
> > > we could then use a similar mechanism.
> >
> > But that is simply not practical - some transactions in the
> > real work will be rolled back - how do you fill the hole,
> > since it will now be out of sequence.
>
> You just do all this with SP's and your own code.

In a multi-user environment you are going to need a lot more than SP's with
their own code. My guess is if you put your system under heavy load it would
blow up readily.

I have an article about what it really takes to do an auditable series of
numbers in a database and to do it right you need considerable mechanisms.
If you want to know how it is really done, check my web-site tech info
sheets.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com