Data.Win.ADODB.TCustomADODataSet.UpdateBatch
Delphi
procedure UpdateBatch(AffectRecords: TAffectRecords = arAll);
C++
void __fastcall UpdateBatch(TAffectRecords AffectRecords = (TAffectRecords)(0x2));
Properties
| Type | Visibility | Source | Unit | Parent | 
|---|---|---|---|---|
| procedure function | public | Data.Win.ADODB.pas Data.Win.ADODB.hpp | Data.Win.ADODB | TCustomADODataSet | 
Description
Writes pending batch updates to disk.
Call UpdateBatch to write any pending updates to disk for a dataset that is in batch update mode to the associated database.
The AffectRecords parameter may be any one of the following TAffectRecords values:
| Option | Meaning | 
|---|---|
| arCurrent | Only the updates for the current row are applied. | 
| arFiltered | Only updates for rows matching the current filter are applied. | 
| arAll | Updates for all rows are applied. | 
| arAllChapters | Update affects all chapters (ADO chapters) | 
Note: To use batch updating, the CursorType property of the dataset component must be either ctKeySet (the default) or ctStatic and the LockType property must be ltBatchOptimistic.