The DynamicObjectQuery class is used for defining class queries based on runtime Object/Bitmap statements. More...
Static Public Member Functions | |
_.Library.Status | Execute (_.Library.Binary qHandle) |
The DynamicObjectQuery class is used for defining class queries based on runtime Object/Bitmap statements. | |
_.Library.Status | Fetch (_.Library.Binary qHandle, _.Library.List Row, _.Library.Integer AtEnd) |
Fetch the next row of data from the query. More... | |
_.Library.Status | FetchRows (_.Library.Binary qHandle, _.Library.Integer FetchCount, _.Library.List RowSet, _.Library.Integer ReturnCount, _.Library.Integer AtEnd) |
FetchRows returns the next FetchCount rows in the query and updates handle for subsequent operations. More... | |
_.Library.Status | Prepare (_.Library.Binary qHandle, _.Library.String query, _.Library.Integer containid, _.Library.String selectmode) |
Prepare the query for execution. More... | |
![]() | |
_.Library.Status | Close (_.Library.Binary qHandle) |
The DynamicSQLQuery class is used for defining class queries based on runtime SQL statements. More... | |
_.Library.Status | GetInfo (_.Library.List colinfo, _.Library.List parminfo, _.Library.List idinfo, _.Library.Binary qHandle, _.Library.Integer extoption, _.Library.List extinfo) |
Returns information about the query. More... | |
![]() | |
_.SQL.StatementResult | Func () |
Func is a method that is used to invoke the query as a function, returning an instance of SQL.StatementResult. | |
SendODBC (_.Library.Binary qHandle, _.Library.String array, _.Library.Integer qacn, _, _.Library.Integer qrc, _.Library.Boolean piece, _.Library.Integer ColumnCount) | |
Fetch and send a series of rows for the ODBC/JDBC server. More... | |
Additional Inherited Members | |
![]() | |
CONTAINID = None | |
SELECTMODE = None | |
The SELECTMODE parameter allows the query author to declare the format of the values returned by the query. More... | |
The DynamicObjectQuery class is used for defining class queries based on runtime Object/Bitmap statements.
|
static |
Fetch the next row of data from the query.
qHandle is query-defined data and is typically updated by Fetch.
The Fetch method should set Row to be a $List of values corresponding to the columns of the query. If we are past the end of the data and no row is returned, Row should be set to null string (""). If the non-empty row being returned is the last one, AtEnd could be optionally set to 1, indicating that an additional call to Fetch may be avoided.
Row may also be subscripted. If any of the columns in the row are stream orefs then the oref type information is lost in the Row $list encoded value. To retain the oref type, place the oref into Row(columnNumber). Library.ResultSet recognizes this form and will extract the column value as the subscripted value.
Reimplemented from DynamicSQLQuery.
|
static |
FetchRows returns the next FetchCount rows in the query and updates handle for subsequent operations.
FetchCount is the number of rows to fetch. If FetchCount is zero then up to 24k of row data is returned. ReturnCount contains the number of rows returned and AtEnd is true if there are no more rows to be fetched. This method does not preserve swizzled streams.
Reimplemented from DynamicSQLQuery.
|
static |
Prepare the query for execution.
For static queries, this method probably just
returns $$$OK. For dynamic queries this method will set up the information returned by GetInfo. It is used by the various ResultSet objects.
Reimplemented from DynamicSQLQuery.