Specifies whether Visual FoxPro processes records marked for deletion and whether they are available for use with other commands.

SET DELETED ON | OFF

Parameters

ON

Specifies that commands that operate on records, including records in related tables, using a scope ignore records that are marked for deletion.

OFF

Specifies that commands that operate on records, including records in related tables, using a scope can access records marked for deletion. (Default)

NoteNote

Calling SQL SELECT with SET DELETED OFF includes records fitting the specified criteria in the result set and sets those records as available for processing. That is, SET DELETED OFF is not set for the records in the result set.

Expand imageRemarks

Expand imageSee Also