ADO: ActiveX Data Objects

Name

FilterGroupEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

The FilterGroupEnum enumeration specifies which groups of records are to be filtered out of the Recordset object.

Table E-25. The FilterGroupEnum Enumeration

Enumeration (ADO/WFC)	Value	Description
adFilterAffectedRecords (AFFECTEDRECORDS)	2	Filters the recordset so that you can see only records affected by the last Delete, Resync, UpdateBatch, or CancelBatch method call.
adFilterConflictingRecords (CONFLICTINGRECORDS)	5	Filters the recordset to include only those records that failed the last batch update.
adFilterFetchedRecords (FETCHEDRECORDS)	3	Filters the recordset so that you can see only records from the last fetch from the database -- only the records in the current cache.
adFilterNone (NONE)	0	Tells the Filter property to remove any current filter and restore the recordset to its original state, showing all records. If you set the Filter property to an empty string (“”), it is the same as setting it to the adFilterNone value.
adFilterPendingRecords (PENDINGRECORDS)	1	Used when in batch update mode. Filters the recordset so that you can see only the records that have since changed but have not yet been sent to the data provider to be saved.

ADO/WFC

The FilterGroupEnum enumeration is part of the com.ms.wfc.data package, and the constant values are preceded with AdoEnums.FilterGroup.

See Also

AffectEnum Enumeration, Recordset.Filter Property