+---------------------------------+
|             DELETE              |
+---------------------------------+
DELETE [<scope>]
        [FOR <expL1>]
        [WHILE <expL2>]
        [NOOPTIMIZE]

-----------------------------------
Marks records for deletion from database.
-----------------------------------

The DELETE command marks records for deletion in the currently selected
database.  Records marked for deletion are not physically removed from
the database file until the PACK command is issued.  Records marked for
deletion may be recalled (unmarked) using the RECALL command.

Records can also be marked for deletion from within a Browse window or
from the Record menu popup.

<scope>
        Marks only records that fall in range of records specified.

FOR <expL1>
        Marks only records that satisfy logical condition <expL1>.

WHILE <expL2>
        Marks records as long as logical expression <expL2> evaluates to true.

NOOPTIMIZE
        Disables Rushmore.

+---------------------------------+
|         Program Example         |
+---------------------------------+
In this example, all customer records with city of PERRYSBURG are marked
for deletion.  Marked records are then recalled (unmarked).

USE customer
DELETE FOR city = 'Perrysburg'
RECALL FOR city = 'Perrysburg'

-----------------------------------

See Also:  DELETED(), PACK, RECALL, SET DELETED

-----------------------------------