ADO: ActiveX Data Objects

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 ...