lester@... wrote:

>
> > 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.