Specifies the text of the current filter for a dataset.
Syntax:
property Filter: String;
Description:
Use Filter to specify a dataset filter. When filtering is applied to a dataset, only those records that meet a filter's conditions are available to an application. Filter contains the string that describes the filter condition.
In Delphi 5 and earlier Variant can not hold int64 type. Thus Filter would not work with TLargeIntField.
For example, the following filter condition displays only those records where the State field is 'CA' or 'MA':
State = 'CA' or State = 'MA'
To filter strings bases on partial comparisons, use an asterisk as a wildcard. For example:
State = 'M*'
Applications can set Filter at runtime to change the filtering condition for a dataset at, for example, in response to user input.
See also: Filtered property