Using Batch Updates

From RAD Studio
Jump to: navigation, search

Go Up to Connecting an ADO Dataset to a Data Store

One approach for caching updates is to connect the ADO dataset to a client dataset using a dataset provider. This approach is discussed in Using a Client Dataset to Cache Updates.

However, ADO dataset components provide their own support for cached updates, which they call batch updates. The following table lists the correspondences between caching updates using a client dataset and using the batch updates features:

Comparison of ADO and client dataset cached updates :

ADO dataset TClientDataSet Description


Not used: client datasets always cache updates

Specifies whether the dataset is opened in batch update mode.


Not used: client datasets always work with an in-memory snapshot of data

Specifies how isolated the ADO dataset is from changes on the server.



Indicates what update, if any, has occurred on the current row. RecordStatus provides more information than UpdateStatus.



Specifies which type of records are available. FilterGroup provides a wider variety of information.



Applies the cached updates back to the database server. Unlike ApplyUpdates, UpdateBatch lets you limit the types of updates to be applied.



Discards pending updates, reverting to the original values. Unlike CancelUpdates, CancelBatch lets you limit the types of updates to be canceled.

Using the batch updates features of ADO dataset components is a matter of:

See Also