1. Home

ADO Filter Property

The Filter property sets or returns a variant that contains a filter for the data in aRecordset object. The filter allows you to select records that fit a specificcriteria."

Syntax

objRecordset.Filter

FilterGroupEnum Values

Constant Value Description
adFilterNone 0 Removes the current filter
adFilterPendingRecords 1 Filter that displays only edited records that have not yet been sent to the server
adFilterAffectedRecords 2 Filter that displays only records affected by the last Delete, Resync, UpdateBatch, or CancelBatch call
adFilterFetchedRecords 3 Filter that displays the records in the current cache
adFilterConflictingRecords 5 Filter that displays those records that failed the last batch update

❮ Complete Recordset Object Reference

Categories

HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

Contact US