Why?
Is this the usual I have to track PO numbers and none can be missing? type
of thing. In the paper world do people lose the PO forms, yes or they make
a mistake and throw them out and get a new one. You could use an autonomous
transaction and track any gaps and then you would know what happened to
"missing" ones for audit purposes.
Jim
"P B" <pbeliveau_at_avcorp.com> wrote in message
news:1j5uqu4r412rcqfjg4d978mhhal5qkimmc_at_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 - 19:15:29 CDT
