Fill Holes in a Sequence
Posted on 2005-03-15
I have a database table, with a field that's has a unique set of numbers , a user can manually enters these values in the database. At the same time I generate a unique number if the user wants to use what I have generated . so in short I am trying to fill the holes in a sequence. Does anyone know how I can go about this
example -- fields values in database
I need to generate a new number that can fill the holes in the sequence, the new number I generate would be.
"5" , as this would be the first hole I found in the sequence. Does anyone know how I can go about this.