Auto Generated Sequence Skipping Numbers
417429Aug 30 2004 — edited Sep 9 2004I am creating an application with which internal customers can make requests. I have a confirmation page which displays to the user a confirmation number from an auto-generated sequence in a column from the table the data is input to. When I'm testing it, and I enter consecutive requests with the application one after the other, it works fine; however, once I leave it and come back to enter another one, the confirmation number the entry is assigned from the auto-generated sequence of numbers skips ahead about 20 numbers. This is not a major issue, as the numbers will still technically remain numerically sequential and distinct, but I'd like to fix this if possible.