Skip to main content

%ResultSet.Result

class %ResultSet.Result extends %Library.IResultSet

This class has been superseded. It will remain for compatibility with existing code and samples. We recommend using %SQL.Statement.

Simple resultset object that does not contain any rows, but just contains the result information

Method Inventory

Parameters

parameter COLUMNCOUNT = 0;

Methods

method %Display(pDelimiter As %String = $Char(9)) as %Library.Status
Display the contents of this object on the current device
method %Get(colname As %String = "") as %Library.String
Returns the value of the column with the name name in the current row of the result set.

If name is not a valid column name, this method returns an empty string.

method %GetData(colnbr As %Integer = 0) as %Library.String
Returns the value of column n in the current row of the result set.
method %Next(ByRef sc As %Library.Status = $$$OK) as %Library.Integer
Advance the result set cursor to the next row. Returns 0 if the cursor is at the end of the result set.
classmethod %Prepare(queryId As %String(MAXLEN=""), ByRef %returnError As %SYSTEM.Error, %importPackages As %RawString = "", %args...) as %Library.IResultSet
Inherited description: %Prepare()

This method is different for each type of result set class. This method has two tasks. First, instantiate the correct concrete result set class. Think of the first parameter, queryId, as being an "index key value" that is used to lookup the correct query implementation. For non-cached (static) queries this is simply the name of the class that implements the query, i.e. the %IResultSet interface. The second task is to prepare the resulting object for data retrieval by the caller.

  • queryId
      This can be the concrete subclass of %IResultSet that implements the desired query. For dynamic cached results this value is generally the query text that can be parsed, a hashed value computed and the cached result implementation class looked up in the query cache index.

      queryId can also be a <className><colon><queryName> or <className><colon><methodName>. If it is a <queryName> then the result set returned is an instance of %Library.ResultSet that is bound to that query. If it is the name of a method Then that method is called, passing %args... to the method, and the first result set found in the context object (%sqlcontext) is returned.

  • %returnError
      If an error occurs this is returned by reference and is a %SYSTEM.Error object with properties set to describe information about the error. %returnError.Status contains the %Status value.

  • %importPackages This is a comma delimited list of packages to import. This is only relevant if the result set implementation is generated and the query source might include unqualified names. The import packages list is used to resolve package/schema names for unqualified names.

  • %args...
      Argument values to be passed to the query/method/class %Execute() method. Zero, one or more argument values can be passed.
    • method %SendODBC() as %Library.Integer
    Fetch and send a series of rows for the ODBC/JDBC server. For internal use only.

    Inherited Members

    Inherited Properties

    Inherited Methods

    FeedbackOpens in a new tab