Query Collection Methods
In this section, we discuss each query collection method.
Syntax
First()
Description
The First method returns the first Query object in the Query collection.
Parameters
None.
Returns
A reference to a Query object if successful, NULL otherwise.
Example
&MyQuery = &MyCollection.First();
Syntax
Item(number)
Description
The Item method returns the Query object that exists at the number position in the Query collection.
Item Considerations
FindQueries and FindQueriesDateRange return both public and private queries. It depends on your database whether the private query is returned first or the public query. If you have two queries with the same name, it depends on your database whether the first use of Item returns the private or the public query.
Parameters
Field or Control |
Definition |
---|---|
Number |
Specify the position number in the collection of the Query object that you want returned. |
Returns
A reference to a Query object if successful, NULL otherwise.
Example
For &I = 1 to &QueryColl.Count;
&MyQuery = &QueryColl.Item(&I);
/* do processing */
End-For;
Syntax
ItemByName(Name)
Description
The ItemByName method returns the Query object with the name Name.
Parameters
Field or Control |
Definition |
---|---|
Name |
Specify the name of an existing Query within the Query collection. If you specify an invalid name, the object is NULL. The length of this parameter is 30 characters. |
Returns
A reference to a Query object if successful, NULL otherwise.
Example
&MyQuery = &MyCollection.ItemByName("PHONELIST");
Syntax
Next()
Description
The Next method returns the next Query object in the Query 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 Query object if successful, NULL otherwise.
Example
&MyQuery = &MyCollection.Next();