QueryRecord Class Properties

In this section, we discuss each QueryRecord class property. The properties are discussed in alphabetical order.

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.

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.

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.

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.

This property returns the name of the record as a string.

The length of this property is 15 characters.

This property is read-only.

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.

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.

Description