| 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