Click above to get retro games delivered to your door ever month!

 SET DELETED
 Toggle filtering of deleted records
------------------------------------------------------------------------------
 Syntax

     SET DELETED on | OFF | <xlToggle>

 Arguments

     ON ignores deleted records.

     OFF processes deleted records.

     <xlToggle> is a logical expression that must be enclosed in
     parentheses.  A value of true (.T.) is the same as ON, and a value of
     false (.F.) is the same as OFF.

 Description

     SET DELETED toggles automatic filtering of records marked for deletion in
     all work areas.  When SET DELETED is ON, most commands ignore deleted
     records.  If, however, you refer to a record by record number (GOTO or any
     command that supports the RECORD scope) the record is not ignored even if
     marked for deletion.  Additionally, SET DELETED ON has no effect on INDEX
     or REINDEXing.

     RECALL ALL honors SET DELETED and does not recall any records.

 Notes

     .  Filtering deleted records in a single work area: To confine
        the filtering of deleted records to a particular work area, SELECT
        the work area, then SET FILTER TO !DELETED().

 Examples

     .  This example illustrates the effect of using SET DELETED:

        USE Sales NEW
        ? LASTREC()                  // Result: 84
        //
        DELETE RECORD 4
        COUNT TO nCount
        ? nCount                     // Result: 84
        //
        SET DELETED ON
        COUNT TO nCount
        ? nCount                     // Result: 83

 Files:  Library is CLIPPER.LIB.