DELETE
Delete a record from a database

Format
 Delete [expr] from [/Qualifiers ...]
 exprKey of the record to delete, for indexed database. Record number of the record to delete, if not indexed. If the key expression (expr) is omitted, the current record is deleted.

Qualifiers
/Fail=LABELLabel to which to branch if the statement fails.
If LABEL is %EXIT, exit the routine or loop.
If in a loop, and LABEL is %CONTINUE, continue the loop. If not in a loop, and LABEL is %CONTINUE, an error message displays.
 /Succeed=LABELLabel to which to branch if the statement succeeds.
If LABEL is %EXIT, exit the routine or loop. If in a loop, and LABEL is %CONTINUE, continue the loop. If not in a loop, and LABEL is %CONTINUE, an error message displays.
 /NofailDo not signal an error. Instead, set the
internal variable %FAIL.
 /Key=DATABASE(#expr)
/Key=DATABASE(#FIELD)
The required key field. This qualifier can be omitted if the operation is on the primary key.
 /RidDo the operation by record ID.
 /RecordDo the operation by record number.

Example
 Delete empkey from EMPLOYEES
 Delete 10 from EMPLOYEES /Record
 ! Delete record 10 from indexed database
 Delete from EMPLOYEES
 ! Delete current record