Christopher P. Boothe wrote:

>I hate having order numbers skip every once in a while when someone cancels
>an entry. Any way to take care of this?

At 12:14 PM 5/18/2001 -0400, Robert F. Tulloch wrote:

> I didn't like that either. If you like I will send you what I did. If I
> remember it
>is an sp which finds the next sequential number, add a record with that
>number then
>returns the number to the call. If you rollback, it cancels the child
>records and
>deletes the one added by the sp. It also handles collisions by waiting
>random length
>of time and trying again. Times out after I think 5 tries.
>
> Works fine.

How many users have you got beating on that simultaneously? We've just
been working with a company that had their system come to a grinding halt
with just this kind of operation - everybody who stored a record had to
update one particular record - performance degraded geometrically as the
number of users went up.

Regards,

Ann