>In FP2.6 apps we used to recycle records by making them empty (scatter memvar blank, gather memvar) and using them again when in need. In some small apps (single user) we marked records for deleted and did a regular pack.
>Does anybody know what is wishdom in VFP to do with records deletion and reuse of records (we are also thinking what implications for possible client/server apps would be.
Here's my $.02 (US)
Always have an index with key set to Deleted(), so you will be able to use full Rushmore optimization on SQL queries/views.
If you are going to do a regular pack/reindex to consolidate memo fields, and if you don't have a large number of records being deleted regularly, then don't bother recycling. You'll save a little time with each record added.
If you have a table that is regularly using and deleting records, (for example a table that holds records of what the on-line users are doing) then you should probably recycle those records. In this case, we leave the record intact but deleted until it is reused, then recall it, blank it and replace the primary ID value when we need a new record.
What is best depends on your system.
HTH
Barbara