%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 informationMethod Inventory (Including Private)
Parameters
Methods (Including Private)
If name is not a valid column name, this method returns an empty string.
If this method returns an error then the object will not be created.
It is passed the arguments provided in the %New call. When customizing this method, override the arguments with whatever variables and types you expect to receive from %New(). For example, if you're going to call %New, passing 2 arguments, %OnNew's signature could be:
Method %OnNew(dob as %Date = "", name as %Name = "") as %Status If instead of returning a %Status code this returns an oref and this oref is a subclass of the current class then this oref will be the one returned to the caller of %New method.
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.
- 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.
- 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.
- Argument values to be passed to the query/method/class %Execute()() method. Zero, one or more argument values can be passed.
Inherited Members
Inherited Properties (Including Private)
- %Message
- %Metadata
- %NextColumn
- %PrivateTables
- %ROWCOUNT
- %ROWID
- %ResultColumnCount
- %RuntimeMode
- %SQLCODE
Inherited Methods (Including Private)
- %AddToSaveSet()
- %ClassIsLatestVersion()
- %ClassName()
- %CloseCursor()
- %ConstructClone()
- %ConstructCloneInit()
- %CreateSnapshot()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DisplayFormatted()
- %Extends()
- %GetMetadata()
- %GetParameter()
- %IsA()
- %IsModified()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OnAddToSaveSet()
- %OnClose()
- %OnConstructClone()
- %OnValidateObject()
- %OriginalNamespace()
- %PackageName()
- %PrepareMetaData()
- %Print()
- %RemoveFromSaveSet()
- %ResultColumnCountGet()
- %SendDelimitedRows()
- %SerializeObject()
- %SetModified()
- %ValidateObject()