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>
|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.|
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.