AffectEnum
Specifies which records are affected by an operation.
| Constant | Value | Description |
|---|---|---|
| adAffectAll | 3 | If there is not a Filter applied to the Recordset, affects all records.
If the Filter property is set to a string criteria (such as "Author='Smith'"), then the operation affects visible records in the current chapter. If the Filter property is set to a member of the FilterGroupEnum or an array of Bookmarks, then the operation will affect all rows of the Recordset. Note adAffectAll is hidden in the Visual Basic Object Browser. |
| adAffectAllChapters | 4 | Affects all records in all sibling chapters of the Recordset, including those not visible via any Filter that is currently applied. |
| adAffectCurrent | 1 | Affects only the current record. |
| adAffectGroup | 2 | Affects only records that satisfy the current Filter property setting. You must set the Filter property to a FilterGroupEnum value or an array of Bookmarks to use this option. |
ADO/WFC Equivalent
Package: com.ms.wfc.data
| Constant |
|---|
| AdoEnums.Affect.ALL |
| AdoEnums.Affect.ALLCHAPTERS |
| AdoEnums.Affect.CURRENT |
| AdoEnums.Affect.GROUP |
See Also
Applies To: CancelBatch Method | Delete Method (ADO Recordset) | Resync Method | UpdateBatch Method