Contents - Methods - Properties
Description
Filter specifier for one column
Contents - TFilterData - Properties
Contents - TFilterData - Methods
CaseSensitive
Delphi declarationColumn
property CaseSensitive: Boolean default True;
C++ declaration
__property bool CaseSensitive={ default=1 }
Description
When true, the filter condition is treated case sensitive.
Delphi declarationCondition
property Column: smallint;
C++ declaration
__property short Column={ nodefault }
Description
Sets the column for which the filter applies
Delphi declaration
property Condition: string;
C++ declaration
__property AnsiString Condition
Description
The Condition property can contain a condition in following formats :substring filterting :
S*, S? : * or ? denote multi or single character matches
>, < , >=, =< : larger than, less than, larger or equal, less or equal (when data is numeric, comparison take place based on numeric data, when a valid date is detected, date comparison is used, otherwise it defaults to alphabetic comparisons)
= , ! : equal or not equal
& : logical AND
^ : logical OR
; : logical OR
Thus, an expression : >20 & <30 is a valid filtering expression as well as !A*