TcxDBFilterOptions.SupportedIn Property

Specifies whether the IN operator is supported by the database system used.

Declaration

property SupportedIn: Boolean read; write; default True;

Property Value

Type	Default
Boolean	True

Remarks

The SupportedIn property indicates whether the IN operator is supported by the database system used for data provision. This property value affects the presence of the in and not in operators within the dropdown list of comparison operators.

The IN conditional operator is really a set membership test operator. That is, it is used in SQL statements to test whether or not a value (stated before the keyword IN) is “in” the list of values provided after the keyword IN. For example:

SELECT emloyeeid, lastname, salary
FROM employee_info
WHERE lastname IN ('Fernandez', 'Jones', 'Roberts', 'Gates');

Although most database systems use ANSI SQL, some also have their own additional proprietary extensions. So, the IN operator may be treated differently by different databases. Its availability depends upon the database you are using. Set the SupportedIn property to False if your database management system does not support the IN operator.

Note

The SupportedIn 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 SupportedIn property is True.