Skip to main content
Version: 5.x

DELETE operator

The DELETE operator creates an action that deletes objects.

Syntax

DELETE expr [WHERE whereExpr]

Description

The DELETE operator creates an action that deletes objects for which a certain condition is met. This operator can add its local parameter, which will correspond to the objects being iterated. In this case, the WHERE block is mandatory.

Parameters

  • expr

    An expression or typed parameter. You can either use an already declared parameter as a typed parameter, or declare a new local parameter. When using an expression, new local parameters cannot be added.

  • whereExpr

    An expression whose value is for the action being created. If not set, it is considered as equal to TRUE.

Examples

// deleting an object
deleteObject(obj) { DELETE obj; }

// deleting all inactive products
CLASS Article;
active = DATA BOOLEAN (Article);
deleteInactiveArticles() {
// a local parameter a is added corresponding to the objects to be iterated over
DELETE Article a WHERE a IS Article AND NOT active(a);
}