QueryRecord Class Properties
In this section, we discuss each QueryRecord class property. The properties are discussed in alphabetical order.
Description
This property returns the short description of the record as a string.
The length of this property is 30 characters.
This property is read-only.
Description
This property returns or sets the join record’s alias, that is, A, B, C, and so on.
This is applicable in any type of join. The value is a string. The length of this property is 1 character.
This property is read-write.
Description
This property returns or sets the join record’s field used in the join criteria. This is applicable in lookup-table joins. The value is a string.
The length of this property is 18 characters.
This property is read-write.
Description
This property returns or sets the join type. This is applicable in any type of join. You can use either a constant or numeric value.
The values for the join type are:
Numeric Value |
Constant Value |
Description |
---|---|---|
1 |
%Query_JoinNone |
Query record isn't joined with any other record. |
2 |
%Query_JoinHierarchy |
Query record has a hierarchy join with another record. |
3 |
%Query_JoinRelated |
Query record has a lookup table join with another record. |
4 |
%Query_JoinTree |
Query record has a tree join with another record. |
5 |
%Query_JoinLeftOuter |
Query record has a left outer join with another record. |
This property is read-write.
Description
This property returns the name of the record as a string.
The length of this property is 15 characters.
This property is read-only.
Description
This property returns a reference to a QueryField Collection that contains instances of all the fields belonging to the record definition.
This property is read-only.
Related Links
Description
This property returns the alias used for the record in the query (that is, A, B, C, and so on.)
The length of this property is 1 character.
This property is read-write.