ADO Recordset Object UpdateBatch Method

Writes all pending batch updates to disk. This method is not currently supported on UNIX.

UpdateBatch Method Syntax

recordset.UpdateBatch AffectRecords

UpdateBatch Method Parameters

AffectRecords

An optional AffectEnum value that determines how many records the UpdateBatch method will affect. Can be one of the following constants:

Constant	Description
AdAffectCurrent	Write pending changes only for the current record.
AdAffectGroup	Write pending changes for the records that satisfy the current Filter property setting. You must set the Filter property to one of the valid predefined constants in order to use this option.
adAffectAll	Default. Write pending changes for all the records in the Recordset object, including any hidden by the current Filter property setting.

UpdateBatch Method Remarks

Use the UpdateBatch method when modifying a Recordset object in batch update mode to transmit all changes made in a Recordset object to the underlying database.

If the Recordset object supports batch updating, then you can cache multiple changes to one or more records locally until you call the UpdateBatch method. If you are editing the current record or adding a new record when you call the UpdateBatch method, ADO will automatically call the ADO Recordset Object Update Method to save any pending changes to the current record before transmitting the batched changes to the provider.

Note

You should use batch updating only with either a keyset or static cursor.

If the attempt to transmit changes fails because of a conflict with the underlying data (for example, a record has already been deleted by another user), the provider returns warnings to the ADO Errors Collection but does not halt program execution. A run-time error occurs only if there are conflicts on all the requested records. Use the ADO Recordset Object Filter Property (adFilterAffectedRecords) and the ADO Recordset Object Status Property to locate records with conflicts.

To cancel all pending batch updates, use the ADO Recordset Object CancelBatch Method.

UpdateBatch Method Example

See the ADO Recordset Object CancelBatch Method example.