Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recycling deleted records?
Message
From
12/05/1999 17:47:58
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Recycling deleted records?
Miscellaneous
Thread ID:
00218107
Message ID:
00218107
Views:
52
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
Map
View

Click here to load this message in the networking platform