Back Previous Next

Syntax:

	delete {record} id {value}/hash {string}
	delete {record} using {sql expression}

Keyword handler:

   linguist.data.keyword.DKDelete.class

Runtime handler(s):

   linguist.data.handler.DHDelete.class

Function:

Delete one or more records from the database. The first form uses the ID of the record (if known) or the string(s) from which the ID can be computed, as defined in the record's specification. The second 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 Order id 300217
   delete Customer id hash Name cat Email
   delete Customer using SQLExpression
   delete Customer using "WHERE city = 'London'"