DELETE
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
DELETE
0 out of 5 stars
| 5 Stars | 0% | |
| 4 Stars | 0% | |
| 3 Stars | 0% | |
| 2 Stars | 0% | |
| 1 Stars | 0% |
Deletes data from EntitySets or relationships with fields.
Syntax
DELETE [num] [setspec] [EVALUATE clause] [-> clause]
Parameters
| num | Can be an integer constant (15, 200); a variable, a form field, or a parameter that evaluates to an integer; the word ALL. If num is omitted, or less than 0, it defaults to 1. |
| setspec | The set specification for the simple set whose records you want to delete. If omitted, records are deleted from the current set (if it exists). |
Comments
Records cannot be deleted from a composite set. Data cannot be deleted from application documents or forms.
If the target of DELETE is a set object or result set, deletion always starts at the current member of the set.
Data removed from the database by a DELETE command cannot be recovered.
Example
delete
Deletes the current member of the current set.
delete 5 Employees where DeptNum = D01
Deletes the first five records in Employees where the department number is D01.
See Also
Updated
ByJason Lee
Was this article helpful?
0 out of 5 stars
| 5 Stars | 0% | |
| 4 Stars | 0% | |
| 3 Stars | 0% | |
| 2 Stars | 0% | |
| 1 Stars | 0% |
5
Portuguese 
English