Navigation:  »No topics above this level«

Xbase Deleted Records

Advantage Concepts

Return to chapter overview

If a delete record operation is performed on a record in a DBF table, the record is not physically removed from the table. Nor is the record logically removed from the table. Depending on the "show deleted records" setting, it may still be possible to view the record. The record is instead "marked for deletion". Optionally, records marked for deletion can still be visible to the application. Records marked for deletion can also be "un-deleted", or "recalled" as it is referred to in Xbase terminology. Thus, the deletion status of a record is nothing more than a filter. If an application is written to allow records marked for deletion to be visible (which is the default), then the record deletion status is irrelevant. If an application is written to ignore records that are marked for deletion, then those records marked for deletion have effectively been filtered from visibility. If the Pack operation is performed on a table, then and only then will records marked for deletion be physically removed from the table.