Overview | Methods | This Package | All Packages

DataSource.setFilter

Sets the criteria for including or excluding records.

Syntax

public void setFilter( String filter )

Parameters

filter

A string that indicates the criteria for the filter.

Remarks

The criteria string is made up of clauses in the form FieldName-Operator-Value. You can join clauses with AND and OR.

• FieldName is a name of a field in the recordset. You should enclose field names that contain spaces in square brackets.
• Operator is one of the following: <, >, <=,>=, <>, =, LIKE. If Operator is LIKE, then Value can use wildcards. The asterisk (*) wildcard matches any number of characters, and the percent sign (%) wildcard matches one character. You can either use a wildcard at the beginning and end of a pattern, or only at the end.
• Value is what you compare to the value of FieldName. Use single quotes with strings and pound signs (#) with dates. For numbers, you can use decimal points, dollar signs, and scientific notation.

See Also   getFilter, ADO Filter property