Leaving "Holes" in a Table

[Charles Yeomans]

On Wednesday, July 16, 2003, at 02:18 PM, Ken Ray wrote:

> When I delete record ID 507 from a table of 1000 records, and then add 
> a new
> record to the table, it gets #507, not #1001 as I would expect. Is 
> there any
> way to make this happen where #507 remains a "hole", and a new record 
> #1000
> is added?

You can do this yourself. Add a VBoolean field IsDeleted, and simply 
set the flag to mark records as deleted (also deleting VBlob fields to 
free up that space).

Charles Yeomans