%DeepSee.SetBuilder.ResultSet

Implementation generated by subclass

Inherited description: 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.

Inherited description: %GetData() Returns the value of the column referenced by colnbr. Object values are not swizzled automatically.

Return the result set metadata as a %SQL.StatementMetadata instance.

Implementation generated by subclass

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.

Inherited description: Implement code to open the cursor here. You may also define new formal arguments. Any arguments defined will be automatically added to the constructor interface and callers can specify actual arguments in the call to %New().

		method %OpenCursor(pBeginDate as %Date = "", pEndDate as %Date = "") as %Library.Status [ private ]
		{
			set ..BeginDate = pBeginDate
			set ..EndDate = $Select(pEndDate'="":pEndDate,1:$H)
			quit $$$OK
		}

Given the above example implementation of %OpenCursor, the following is a valid call to instantiate a new instance.

		set tResult = ##class(MyCustom.ResultSet).%New(,$H-30,$H-10)

To report an error from %OpenCursor just set ..%SQLCODE and %Message to appropriate values. To report no rows found, set %SQLCODE to 100. Errors are indicated by negative ..%SQLCODE values.