TcxDBFilterOptions.SupportedLike Property
Specifies whether the LIKE operator is supported by the database system used.
Declaration
property SupportedLike: Boolean read; write; default True;
Property Value
Type | Default |
---|---|
Boolean | True |
Remarks
The SupportedLike property indicates whether the LIKE operator is supported by the database system used for data provision. This property value affects the presence of the like and not like operators within the dropdown list of comparison operators.
The LIKE pattern matching operator can be used in SQL statements to select only rows that are “like” what you specify. The percent sign ‘%’ (or other specified by the PercentWildcard property) can be used as a wildcard to match any possible character that might appear before or after the characters specified. For instance:
SELECT emloyeeid, lastname, salary
FROM employee_info
WHERE lastname LIKE 'F%';
Although most database systems use ANSI SQL, some also have their own additional proprietary extensions. So, the LIKE operator may be treated differently by different databases. Its availability depends upon the database you are using. Set the SupportedLike property to False if your database management system does not support the LIKE operator.
Note
The SupportedLike property should be set to False if you perform dataset filtering using the dataset’s filter support mechanism (i.e., when you assign the FilterText property value to the Filter property of the dataset and then set the dataset’s Filtered property to True).
The default value of the SupportedLike property is True.