Topic group Related topics
Controls whether dBASE Plus hides records marked as deleted in a DBF table.
SET DELETED ON | off
Use SET DELETED to include or exclude records marked as deleted in a DBF table. When SET DELETED is OFF, all records appear in a table. When SET DELETED is ON, dBASE Plus excludes records that have been marked as deleted, hiding them from most operations.
INDEX, REINDEX, and RECCOUNT( ) aren't affected by SET DELETED.
If two tables are related with SET RELATION, SET DELETED ON suppresses the display of deleted records in the child table. The related record in the parent table still appears, however, unless the parent record is also deleted.
Soft deletes are not supported.