Skip to main content

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.

See Also