Re: Re: Sequence Number Re-use is it possible, what is the standard

have you considered postponing the assignment of the unique sequence number until a row is actually inserted into the table? i'm thinking that your "problem" could be resolved with a small change to the application design.

a "bid" isn't really a "bid" until it is "saved", so it doesn't really make sense to acquire and assign a unique key until it is inserted into the table.

sequences are designed to solve the need for a unique identifier. just a thought.

<u28656005_at_spawnkill.ip-mobilphone.net> wrote in message news:r.983458782.1579010009@[208.50.67.66]...
> Thanks for the response.
>
> We are already using NOCache. I think we are just wondering if anyone has
 put
> the unused numbers into another table so the front-end can get it from
 there or
> the sequence number to not have big gaps.
>
> I also added functionality on the front-end to show a screen to ask them
 to
> save, if they haven't already, so it won't skip as much. I know that will
 help
> tremendously.
>
> However, when we get to some of our more complex systems, like our
 purcahsing
> system, it might need a more elegant solution.
>
> Thank you everyone who has replied so far.
>
> Mark
>
>
>
>
>
>
>
>
> --
> Spam protected message from:
> Sent by mspritzler from sasco within field com
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Sat Mar 03 2001 - 17:58:54 CST