Returns the value of the column with the name colname in the current row of the result set.
If colname is not a valid column name, this method throws a error.
method GetBuffer(ByRef moreBuffers As %Boolean) as %List
Returns the current row buffer to the caller.
This method will refuse to return the buffer if there result set is already
being iterated over by cursor (if the cursor is not before the start of the result set)
Returns 1 if more buffers exist, 0 if this is the last buffer
Inherited description: Advance to the next row in the result referenced by %ProcCursor. Returns 0 if the cursor is at the end of the
result set. An optional argument contains a %Library.Status value on return. This %Status value
indicates success or failure of the %GetRow() call. %SQLCODE is also set by %GetRow().
The row is returned in $List format by reference in the Row argument. If %SQLCODE'=0, Row will be null ("").
This implementation is overridden by classes that implement the result set interface.
Advance the next rowCount rows in the result. Returns 0 if the cursor is at the end of the
result set. Note, when 0 is returned, it is likely there are rows returned in the rows array. An optional argument contains a %Library.Status value on return. This %Status value
indicates success or failure of the %GetRows() call. %SQLCODE is also set by %GetRows.
The rows are returned in an array of $List values in the Row array argument. If %SQLCODE'=0 for a row, that will be the end of the results.
For example, suppose rset.%GetRows(10,.tenrows,.sc) is called:
- If there are more then 10 rows remaining to be fetched from the result set, tenrows=10, tenrows(1)=$lb(first row's contents), ..., tenrows(10)=$lb(tenth row's contents), and %GetRows() will return 1.
- If there are 5 rows remaining to be fetched from the result set, tenrows=5, tenrows(1)=$lb(first row's contents), ..., tenrows(5)=$lb(fifth row's contents), and %GetRows() will return 0.
- If there are 0 rows remaining to be fetched from the result set, tenrows=0 and %GetRows() will return 0.
This implementation is overridden by classes that implement the result set interface.
Signature/behavior here to match that of %SQL.StatementResult:%GetRows()
Getter method for the %isBeforeFirst property on this class, which tracks
whether the IRIS-side result set is before the first row and may not match up with
whether the Java-side result set is before the first row.
Inherited description: Advance to the next row in the result referenced by %ProcCursor. Returns 0 if the cursor is at the end of the
result set. An optional argument contains a %Library.Status value on return. This %Status value
indicates success or failure of the %Next call. %SQLCODE is also set by %Next.
This implementation is overridden by classes that implement the result set interface.