Syntax

bSuccess=rst.UpdateBatch(affectRecords)

Parameters

affectRecords
Optional. An Integer value that determines how many records the CancelBatch method will affect. The default value is adAffectAll. It can be one of AffectEnum values.

Returns

True (1) if function completed successfully, false (0) otherwise.

Description

Calls the UpdateBatch() method of the wrapped ADODB.Recordset object. 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, 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. You should use batch updating with either a keyset or static cursor only.
Not supported in ADOxtraLite version.