Microsoft Remote Data ServiceMicrosoft Remote Data Service*
*Contents  *Index  *Topic Contents

FilterCriterion Property

Sets or returns which evaluation operator to use in the filter value.

Syntax

DataControl.FilterCriterion = String
PartDescription
DataControlAn object variable that represents an RDS.DataControl object.
StringA String value that specifies the evaluation operator of the FilterValue to the records. Can be any one of the following: <, <=, >, >=, =, <>.

Applies To

RDS.DataControl

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 a find criteria, while the full recordset is maintained in the cache. The Reset method will execute the criteria and replace the current recordset with a read-only recordset.

The != operator is invalid for FilterCriterion; instead, use <>.

If both the filter and sort properties are set and you call the Reset method, the rowset is first filtered and then it is sorted. For ascending sorts, the NULLs are at the top, descending sorts NULLs are at the bottom (ascending is default behavior).

Example

See Also

Sorting and Filtering

Up Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.