General information
Category:
Coding, syntax & commands
Title:
Recycling deleted records?
Back in the days of FoxPro 2.x it was fairly easy to put some code in Save routines to look for a deleted record and RECALL it if one existed and then GATHER MEMVAR (or whatever), else append a new record to save into. This was a good way to keep down dbf file bloat caused by deleted records.
With Visual FoxPro's use of buffered tables and views there doesn't seem to be any straightforward way of recycling deleted records in this way. TableUpdate() is always going to create new records in the underlying table.
I'm curious to know if anyone has any strategies for dealing with bloat caused by deleted records - other than PACK?
David
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only