Hi,
I would have to agree with Roel,
But you can't skip them in numeration
A deleted record in the database file provide by Sun is not the same as a deleted
record in an actual RDBMS.
What this means is, if you were to execute the delete method on your database file,
you shouldn't completely remove the record information and the record number. Either
the space which the previous record used to occupy will be available for reuse and will
be reused when creating a new record, or you can opt out not to reuse the record space.
Either way, you have to write that deleted (or possibly a new record in its place) record
back to the file.
Vlad