Name
AffectEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
The AffectEnum enumeration indicates which records are affected by an invoked operation.
Table E-5. The AffectEnum Enumeration
|
Enumeration (ADO/WFC) |
Value |
Description |
|---|---|---|
adAffectAll (ALL) |
3 |
Indicates that all records will be affected by the operation if there is no Filter applied or if a Filter is set to a member of the FilterGroupEnum enumeration or an array of bookmarks. If the Filter property is set to a String value, then the operation will affect only those rows that are visible within the current chapter. |
adAffectAllChapters (ALLCHAPTERS) |
4 |
Indicates that all records in all sibling chapters of the Recordset object will be affected by the operation. This includes those records not visible with an applied filter. |
adAffectCurrent (CURRENT) |
1 |
Indicates that only the current row will be affected by the operation. |
adAffectGroup (GROUP) |
2 |
Indicates that all records, which satisfy the current Filter if it is set to a member of the FilterGroupEnum enumeration or an array of bookmarks, will be affected. |
Note
The adAffectAll enumeration value does not appear in the Object Browser.
ADO/WFC
The AffectEnum enumeration is part of the com.ms.wfc.data package, and the constant values are preceded with AdoEnums.Affect.
See Also
FilterGroupEnum Enumeration, Recordset.CancelBatch Method, Recordset.Delete Method, Recordset.Resync Method, Recordset.UpdateBatch Method, Recordset.Filter Property, FilterGroupEnum Enumeration ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access