Syntax:
delete {record}
delete {record} id {value}
delete {record} using {sql expression}
Keyword handler:
net.eclecity.linguist.data.keyword.DataKDelete.class
Runtime handler(s):
net.eclecity.linguist.data.handler.DataHDelete.class
Function:
Delete one or more records from the database.
The first form deletes the record having the ID field value given by the record variable.
The second form uses the given ID.
The third form deletes all records that match the given SQL expression.
The deletions will be performed on the local, cached copies of the records, but no changes will be made to the SQL database until the commit command is given.
Example(s):
delete Customer delete Order id 300217 delete Customer id Name delete Customer using SQLExpression delete Customer using "WHERE city = 'London'"