FilterValue Property (RDS)

Microsoft ActiveX Data Objects (ADO)

FilterValue Property (RDS)

       

Indicates the value with which to filter records.

Syntax

DataControl.FilterValue = String

Parameters

DataControl   An object variable that represents an RDS.DataControl object.

String   A String value that represents a data value with which to filter records (for example, 'Programmer' or 125).

Remarks

The SortColumn, SortDirection, FilterValue, FilterCriterion, and FilterColumn properties provide sorting and filtering functionality on the client-side cache. The sorting functionality orders records by values from one column. The filtering functionality displays a subset of records based on find criteria, while the full Recordset is maintained in the cache. The Reset method will execute the criteria and replace the current Recordset with an updatable Recordset.

Null values result in a type mismatch error.