Re: Sequence without holes

In article <1j5uqu4r412rcqfjg4d978mhhal5qkimmc_at_4ax.com>, pbeliveau_at_avcorp.com wrote:

>I would like to have a sequence but as I understand it, if for some
>reason a user make a rollback or what so ever, I loose his sequence
>number.
>
>I don't want that. I want a sequence that has no hole, so if a user
>make a rollback, the next user that request a number would receive the
>number that was rolled back.

I don't think there's a way to do that, but getting the next number from the sequence last will help. :-)

-- 
======================================================================
ISLAM: Winning the hearts and minds of the world, one bomb at a time.