Item method: Query collection

Syntax

Item(number)

Description

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

Parameters

Parameter Description

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;

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.