Creates a select query for one or more tables of an API connection.
The API connection.
Reposition the query backward with a number of records.
Closes the query, no other operation is possible afterwards.
It is recommended to close a query when not needed anymore to free-up resources on the 4GL agent. Otherwise the resources used by the query will hang up until the connection is closed.
Returns the number of rows in the query.
Deletes the current record in the query.
Deletes all records in the query, when resolved it returns the number of records deleted.
Asynchronously executes a callback function for each record of the query. The callback function receives the query record as first parameter and optionally the query index.
Regardless of the current query index the query starts from the first record and at the end the query index is always on the last record.
The callback function to be executed for each record in query.
Returns the table(s) fields in the query.
Retrieves the first record from the query.
Reposition the query forward with a number of records.
Retrieve a record from the query, reposition as needed. If reposition is not specified it returns the current record if available or fetchs the first one otherwise.
Retrieves the last record from the query.
Retrieves the next record from the query.
Retrieves the previous record from the query.
Reposition the query to a specific index - this is either a number (zero base) or 'last', 'first'.
Class for creating and then managing a sequential query.