EPUB | CHM | PDF

TPSQLDataset.Properties.FilterOptions

Top Previous Next

Specifies whether filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records.

Syntax:

property FilterOptions: TFilterOptions;

Description:

Set FilterOptions to specify whether or not filtering is case insensitive when filtering on string or character fields, and whether or not partial comparisons for matching filter conditions is allowed.

By default, FilterOptions is set to an empty set. For filters based on string fields, include foCaseInsensitive in FilterOptions to catch all variations on a string regardless of capitalization.

To prevent partial string comparisons, include foNoPartialCompare in FilterOptions.

To filter strings bases on partial comparisons, exclude foNoPartialCompare from FilterOptions and use an asterisk as a wildcard.

For example:

State = 'M*'