In DObject O/R Mapping persistence layer, the way using OQL to delete objects in batches is as follows:
|
var query : IDeleteQuery; begin query := TDeleteQuery.Create; query .DeleteFrom(NW.Order) .Where( OQL .Criteria(NW.Order.CustomerID).EQ('ATEST') .And_(NW.Order.ShipVia).EQ(1) ); ObjectManager.ExecuteCommand(query); end; |
Related Topics