QueryExpression Class Properties
In this section, we discuss the QueryExpression class properties. The properties are discussed in alphabetical order.
Description
This property specifies whether the expression is an aggregate function.
This property takes a Boolean value: True if the expression is an aggregate function, False, otherwise.
This property is read-write.
Description
This property specifies whether the expression contains a bind value, as Boolean value.
This property is mainly used while reading a query, to determine whether a Query Expression contains a bind value. It isn't necessary to set this value while saving a query to the database.
Values are:
|
Value |
Description |
|---|---|
|
False |
Expression doesn't have a bind value |
|
True |
Expression has a bind value |
This property is read-write.
Description
This property returns or sets the decimal value of the expression.
This property is only valid with numeric fields.
This property is read-write.
Description
This property returns or sets the unique expression number, as a numeric value.
This property is read-write.
Description
This property indicates whether the expression is for a translate field. This property takes a Boolean value: True, the expression is based on a translated field.
This property is read-only.
Description
This property returns or sets the length of the expression, as a number.
This property is read-write.
Description
This property returns the name of the expression, as a string.
This property is read-only.
Description
This property returns the instance of the displayed expression field, as a QueryField. This property returns a NULL when the expression isn't used in a displayed (output) field.
This property is read-write.
Description
This property specifies whether an expression is used in the right-hand side of a criteria (that is, is it an Expr2 expression), as a Boolean value.
This property is typically used while reading a query to determine whether a Query Expression is used in the right-hand side of criteria. It's not necessary to set this value while saving a query to the database.
Values are:
|
Value |
Description |
|---|---|
|
False |
Expression is not used in the right-hand side of the criteria |
|
True |
Expression is used in the right-hand side of the criteria |
This property is read-write.
Description
This property returns the instance of the expression field, as a QueryField. This property returns a NULL when the expression is used only in the right-hand side of a criteria.
This property is read-write.
Description
This property returns or sets the text of the expression, as a character string.
This property is read-write.
Using ORACLE Hints in Expressions
Oracle hints can be included in expressions using the following considerations:
Expression containing a hint must begin with /*+.
Expression can only contain one hint. For example, only one set of /* */ is allowed in each expression.
Each /* must precede an */.
Each expression must contain a complete hint. For example, an expression can't have only /* or */. Both must be in same expression.
Description
This property returns or sets the field type of the expression.
You can specify either a constant or a numeric value. The values are:
|
Numeric Value |
Constant Value |
Description |
|---|---|---|
|
0 |
%FieldType_Char |
Character |
|
1 |
%FieldType_LongChar |
Long Character |
|
2 |
%FieldType_Number |
Number |
|
3 |
%FieldType_SignedNumber |
Signed number |
|
4 |
%FieldType_Date |
Date |
|
5 |
%FieldType_Time |
Time |
|
6 |
%FieldType_DateTime |
DateTime |
|
7 |
%FieldType_Image |
Image |
|
11 |
%FieldType_URL |
Drilling URL |
This property is read-write.