Using Query::delete_from() to delete data by query ranges

on

Query framework is often used to build dynamic queries at runtime. Besides selecting and filtering data, you can also use the query object to delete records that match specific criteria.

The method Query::delete_from() converts your query definition into a delete_from statement and removes all records that satisfy the query conditions.

Query query = new Query();
QueryBuildDataSource qbds = query.addDataSource(tableNum(TableName));
// Add a range for ItemId = 'A0001'
qbds.addRange(fieldNum(TableName, ItemId)).value(queryValue('A0001'));

Query::delete_from(query);