Method SqlStatement:query() Foundation

Executes the given SQL statement which returns a single ResultSet. The result-set is processed according to the <nResultType> definition.

METHOD :query([nResultType], [<@xResult> | <cAlias>] ) -> <cAlias>
A define from <> which determines how the result-set shall be processed.
Possible ways to handle a result-set
#define Description
USQL_RESULT_WORKAREA* The result set is retrieved and available as a workarea in the current workspace. Pass optional Aliasname.
USQL_RESULT_ARRAY The result set returned in an array, where each row is an subarray.
USQL_RESULT_OBJECTS The result set returned in an array of objects. By default all objects are DataObjects where the prototype name is the the alias name.
USQL_RESULT_EVAL The result set not saved on, instead each row of the result is passed as an array to the codeblock wich gets then evaluated.
USQL_RESULT_SINGLE_VALUE The result set is assumed to return only one column/one row therefore this single value is assigned to the by reference parameter.
  1. Default
A variable passed by reference of any type which recieves the result value as specified via the <nResultType> parameter.
An character string or expression returning an characters string which determines the alias name under which the result set is reference in the current workspace. If the alias name does already exist the ordinal of the workarea is appended to the alias name.

This method returns the aliasname of the workarea or the dataobject prototype


The method :query() is used to retrieve a single result set from the DBMS.


If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.