Writes all pending batch updates to disk.
Syntax
recordset.UpdateBatch AffectRecords
The UpdateBatch method syntax has these parts:
Part |
Description |
recordset |
An object variable representing an open Recordset object. |
AffectRecords |
Optional. A Long expression that determines how many records the UpdateBatch method should act on. Can be one of the following constants: |
adAffectCurrent, 1 - Write pending changes only for the current record. adAffectGroup, 2 - 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, 3 (Default) - Write pending changes for all the records in the Recordset object, including any hidden by the current Filter property setting. |
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 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 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 Filter property (adFilterAffectedRecords) and the Status property to locate records with conflicts.
To cancel all pending batch updates, use the CancelBatch method.