Tables should have a new property (let's call it Tableview) which can be set to the following values:

1 - Normal mode

2 - Ignore deleted records

3 - Ignore deleted records and recycle


The normal mode indicates that VFP handles the table in the regular way.

The ignore deleted records mode, indicates that VFP ignores the deleted records totally under any circumstances (so even when set deleted = off). The main advantage of this is that indexes are automaticly scoped to the non-deleted records and are rushmore optimizable. This will reduce the size of indexfiles which also have an performance advantage. Primary indexes won't need a FOR DELETED() filter because the index is already scoped to non-deleted records. The only way to view the deleted records is to change this 'Tableview' property.

The ignore deleted records and recycle mode, will ignore deleted records in the same way as the former mode, but will also recycle deleted records. This means that if an records is added (With INSERT, APPEND BLANK, APPEND FROM, etc.) the system first will look for (invisible physical) deleted records in the tables and recycle them. If they're not available they will be appended at the end of the file. This option will greatly reduce the requirement of packing highly dynamical tables.

This wish must be regarded of a replacement of the "SET RECYCLE" and the "Indexes scoped to non deleted records using rushmore" wishes.

Walter,