Setting filter options

The FilterOptions property lets you specify whether a filter that compares string-based fields accepts records based on partial comparisons and whether string comparisons are case-sensitive. FilterOptions is a set property that can be an empty set (the default), or that can contain either or both of the following values:

Table 24.5 FilterOptions values

Value

Meaning

foCaseInsensitive

Ignore case when comparing strings.

foNoPartialCompare

Disable partial string matching; that is, don't match strings that end with an

asterisk (*).

For example, the following statements set up a filter that ignores case when comparing values in the State field:

FilterOptions := [foCaselnsensitive]; Filter := 'State = ' + QuotedStr('CA');

Was this article helpful?

+1 0

Post a comment