Command DELETE Foundation
Marks one or more records for deletion.
DELETE ; [FOR <lForCondition>] ; [WHILE <lWhileCondition>] ; [NEXT <nCount>] ; [RECORD <xRecordID>] ; [REST] ; [ALL] ; [IN <nWorkArea> | <cAlias> ] ; [NOOPTIMIZE]
The file command DELETE marks records in the current work area as "Deleted." When the command is used without arguments, only the current record is marked as "Deleted." DELETE logically deletes data records and does not physically remove them from the DBF file. The deletion flag is displayed with an asterisk (*) in the output of the commands LIST and DISPLAY.
The visibility of the records marked as "Deleted" is determined by the command SET DELETED ON | OFF. If SET DELETED is turned ON and the current record is marked for deletion, the record remains visible until the record pointer is moved. Records marked for deletion can be "undeleted" using the command RECALL. The command PACK physically removes all records marked for deletion from a file. The command ZAP is used to physically delete all records from a file at one time.
The function DbDelete() called within the code block passed to DbEval() performs the functional equivalent of the DELETE command.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.