TcxDBFilterOptions.SupportedBetween Property

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

Declaration

property SupportedBetween: Boolean read; write; default True;

Property Value

Type	Default
Boolean	True

Remarks

The SupportedBetween property serves to indicate whether the BETWEEN operator is supported by the database system used for data provision. This property controls whether the between and not between operators are provided within the comparison operators dropdown list.

The BETWEEN conditional operator is used in SQL statements to test whether or not a value (stated before the keyword BETWEEN) is “between” the two values stated after the keyword BETWEEN. For instance:

SELECT emloyeeid, lastname, age, salary
FROM employee_info
WHERE age BETWEEN 30 AND 40;

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

Important

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