RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TCustomADODataSet.DeleteRecords Method

Deletes one or more records in the dataset.

Pascal
procedure DeleteRecords(AffectRecords: TAffectRecords = arAll);
C++
__fastcall DeleteRecords(TAffectRecords AffectRecords = arAll);

Use DeleteRecords to delete one or more records from the recordset the ADO dataset component represents. 

If the recordset does not support record deletions, an exception is raised. Use the Supports method to determine whether the recordset supports deleting records. 

If the dataset was opened in batch update mode, the records are only marked for deletion. Apply the batch deletions by calling the UpdateBatch method. If the dataset is not in batch update mode, the records are immediately removed from the base table. 

AffectRecords is a TAffectRecords constant that determines which records are deleted by DeleteRecords. The default value for the AffectRecords parameter is arAll, which causes all records in the recordset to be deleted.

Option 
Meaning 
arCurrent  
Only the deletes the current record.  
arFiltered  
Only deletes records accessible through the current filter.  
arAll  
Deletes all records in the recordset.  
arAllChapters  
Deletes records in all chapters (ADO chapters)  

 

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!