Topic group Related topics

Controls whether dBASE Plus hides records marked as deleted in a DBF table.

Syntax

SET DELETED ON | off

Description

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.

OODML

Soft deletes are not supported.