Skip to main content

%ResultSet.Result

Class %ResultSet.Result Extends %IResultSet [ System = 2 ]

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

Parameters​

COLUMNCOUNT​

Parameter COLUMNCOUNT = 0;

Methods​

%Get​

Method %Get(colname As %String = "") As %Library.String [ CodeMode = expression ]

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.

%GetData​

Method %GetData(colnbr As %Integer = 0) As %Library.String [ CodeMode = expression ]

Returns the value of column n in the current row of the result set.

%Next​

Method %Next(ByRef sc As %Library.Status = {$$$OK}) As %Library.Integer [ CodeMode = expression ]

Advance the result set cursor to the next row. Returns 0 if the cursor is at the end of the result set.

%SendODBC​

Method %SendODBC() As %Library.Integer [ CodeMode = expression ]

Fetch and send a series of rows for the ODBC/JDBC server. For internal use only.

%OnNew​

Method %OnNew(SQLCode As %Integer = 0, Message As %String(MAXLEN=256) = "", RowCount As %Integer = 0) As %Status [ Private, ProcedureBlock = 1 ]

%Prepare​

ClassMethod %Prepare(queryId As %String(MAXLEN=""), ByRef %returnError As %SYSTEM.Error, %importPackages As %RawString = "", %args...) As %Library.IResultSet

%Display​

Method %Display(pDelimiter As %String = {$Char(9)}) As %Library.Status

Display the contents of this object on the current device