---

DELETE

Delete a record from a database

---

Format
	Delete [expr] from [/Qualifiers ...]
	expr	Key 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=LABEL	Label 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=LABEL	Label 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.
	/Nofail	Do 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.
	/Rid	Do the operation by record ID.
	/Record	Do 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