QueryRecord Collection Methods

In this section, we discuss each QueryRecord collection method. The methods are discussed in alphabetical order.

Syntax

First()

Description

The First method returns the first QueryRecord object in the QueryRecord collection.

Parameters

None.

Returns

A reference to a QueryRecord object if successful, NULL otherwise.

Example

&MyQueryRecord = &MyCollection.First();

Syntax

Item(number)

Description

The Item method returns the QueryRecord object that exists at the number position in the QueryRecord collection.

Parameters

Field or Control	Definition
`Number`	Specify the position number in the collection of the QueryRecord object that you want returned.

Returns

A reference to a QueryRecord object if successful, NULL otherwise.

Example

For &I = 1 to &QueryRecordColl.Count; 
   &MyQueryRecord = &QueryRecordColl.Item(&I); 
   /* do processing */ 
End-For;

Syntax

ItemByAlias(Alias)

Description

The ItemByAlias method returns the QueryRecord object specified by Alias.

Parameters

Field or Control	Definition
`Alias`	Specify the record alias (for example, A, B, C, and so on), used in the SQL statement as a TableName alias.

Returns

A reference to a QueryRecord object if successful, NULL otherwise.

Example

&MyQueryRecord = &MyCollection.ItemByAlias("A");

Syntax

Next()

Description

The Next method returns the next QueryRecord object in the QueryRecord collection. You can use this method only after you have used the First method: otherwise the system doesn’t know where to start.

Parameters

None.

Returns

A reference to a QueryRecord object if successful, NULL otherwise.

Example

&MyQueryRecord = &MyCollection.Next();