Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Wishlist: SET RECYCLE on and Index on Deleted records
All,
To Enhance concurrency and decrease the need to pack tables, the following might be a welcome enhancement:
VFP should have the possibility of natively recycle deleted records, so the need of packing tables is reduced. Then tables won't grow larger and larger. NOTE: this only applies to tables, not memo files.
This switch might be set with a
SET RECYCLE ON command.
Every INSERT or APPEND command would make VFP search for a deleted record, fill the contents of the table and clear the deleted mark of the table.
This is now virtually impossible: though you could program this approach for native tables, if you make use of VIEWS, you're not able the recycle recrords in the underlying table.
To accomplish this matter, we also must have a possibility to quickly lookup deleted records. This could be done with an index like:
INDEX ON .T. FOR DELETED()
To hide or emphasize this special index for the user it might be handy to make this index with the following INDEX command:
INDEX ON DELETEDRECORDS
Walter,
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