![]() |
![]() |
|||||||
|
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. |
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.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.Example
See the CancelBatch method example.Copyright © 2000 Chili!Soft