DELETE

DELETE

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

DELETE

Deletes data from EntitySets or relationships with fields.

Syntax

DELETE [num] [setspec] [EVALUATE clause] [-> clause]

Parameters

numCan 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.
setspecThe 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

$MemberCount

DELETE FROM

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
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

pt_BRPortuguese