Sequence without holes

From: P B <pbeliveau_at_avcorp.com>
Date: Thu, 17 Oct 2002 16:06:30 -0400
Message-ID: <1j5uqu4r412rcqfjg4d978mhhal5qkimmc@4ax.com>

Question #1

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.

Question #2

How do I lock a row that does not exist? I did not yet insert the row but I will soon and I don't want other user to use my key. I dont want to lock the whole table because I'm not the only who use it. Received on Thu Oct 17 2002 - 15:06:30 CDT