Property Reference > Quick Reference for All Properties > Comparison Property |
C1QueryFrame.Item.Comparison = value
Notes
Read-write at run time. Unavailable at design time. Property applies to QueryItem object.
Values
Constant Value |
Name |
Meaning |
0 |
c1qComparisonEQ |
= (equal) |
1 |
c1qComparisonGT |
>= (greater than) |
2 |
c1qComparisonLT |
< (less than) |
3 |
c1qComparisonGE |
>= (greater than or equal) |
4 |
c1qComparisonLE |
<= (less than or equal) |
5 |
c1qComparisonNEQ |
<> (not equal) |
6 |
c1qComparisonIsNull |
is NULL |
7 |
c1qComparisonIsNotNull |
is not NULL |
8 |
c1qComparisonContains |
contains |
9 |
c1qComparisonStartsWith |
starts with |
Description
This property returns/sets the comparison operation of an elementary condition item. Not all comparisons are applicable to all data types: “contains" and “starts with” are only applicable to strings; Booleans can only be compared with = and <>.
See Also
Accessing and Modifying Query Items