> No its not luck - the design just works and you missed it in your
> considerations above. I tested on a local machine with 10 copies of a
> program that just created 1,000 invoices as fast as it could. When done I

That is the problem with this test - introduce some realtime
random delays in adding the invoices?

> verified that all the numbers were used and none skipped. I also tested with
> some of the test programs doing rollbacks so that I could see if this was
> working properly too. This *really* hammered the database. It was all local
> access so no network speed issues and the load was huge. I'm very confident
> that this code works properly.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services