Attribute | Data Type | Description | Inherited From |
AcrossValues | array of QueryCol | Stores the array of values on which the returned data is based (RW) | CrossTable |
Aggregate | QueryCol | Stores the aggregate value mapped to a particular cell in the CrossTable display (RW) | CrossTable |
Breaks | array of BreakSpec | Stores the data stream's data breaks in sorted order by break level (R) | DataStream |
ClassName | varchar(32) | Gives the name of an object's actual type (as opposed to its declared type) (R) | Object |
ClientData | Object | Provides a way to associate data with an object (RW) | Object |
ClientInteger | integer | Specifies an arbitrary integer for use by the user (RW) | DataStream |
Columns | array of QueryCol | Is an array of target list column definitions (RW) | DataStream |
CrossColumn | QueryCol | Stores the database column name that has values represented as column headers in ColumnCross reports and are repeated as rows in RowCross reports (RW) | CrossTable |
CurBreakLevel | smallint | Contains the value of the current break level (R) | DataStream |
CurRow | integer | Provides the row number of the current retrieved row of the query (R) | DataStream |
DBSession | DBSessionObject | Represents the database session created when the SQLSelect object was last opened (R) | SQLSelect |
DesignTimeWhere | StringObject | Used to define the where clause for your QueryObject (RW) | QueryObject |
ErrorNo | integer | Provides the error number of the last operation (R) | DataStream |
HavingClause | StringObject | Contains the SQL having clause (RW) | QueryObject |
InstanceIdentifier | integer | Contains a value that uniquely identifies an instance of an allocated object (R) | Object |
InstanceReferences | integer | Contains the current number of references to the object (R) | Object |
IsDBError | integer | Is TRUE if the error is a database error (R) | DataStream |
IsDistinct | smallint | Is TRUE if a query is select distinct (RW) | QueryObject |
MaxRow | integer | Provides the row number of the maximum row of the query (R) | DataStream |
Name | varchar(32) | Stores the optional user-defined name assigned to identify a query (RW) | DataStream |
NextBreakLevel | smallint | Contains the value of the next break level (R) | DataStream |
Query | StringObject | Contains the SQL query text, which can contain parameter substitutions. The parameters are OpenROAD expressions evaluated with reference to a given scope (R) | SQLSelect |
QueryMode | smallint | Specifies the current mode of the query (R) | DataStream |
QueryName | varchar(32) | Specifies the server name to use for cursors and repeat queries (RW) | SQLSelect |
RunTimeWhere | StringObject | Contains where clause elements to which you can add 4GL code without interfering with the DesignTimeWhere or DynQualWhere attributes (RW) | QueryObject |
Scope | Scope | Represents the scope used to compile and evaluate dynamic expressions (RW) | DataStream |
State | smallint | Represents the state of the query (R) | DataStream |
SupressErrorTrace | smallint | If TRUE, does not print non-database error messages to the trace window from the data stream's methods (RW) | DataStream |
Tables | array of QueryTable | Contains information about the tables participating in the query (RW) | QueryObject |
TargetArray | ArrayObject | Holds the array associated with a frame's table field (RW) | DataStream |
TargetPrefix | varchar(256) | Specifies that a prefix is to be attached to all compiled expressions used in target mappings (RW) | DataStream |
Method | Return Value | Description | Inherited From |
AddBreak (columnindex = integer, level = integer [,formatstring = varchar(256)]) | none | Adds a new break condition to the data stream | DataStream |
ClearBreaks() | none | Removes all break conditions from the data stream | DataStream |
Close() | none | Closes the query | DataStream |
CommitToCache() | integer | Keeps data in the cache consistent with data in the database when insert, update or delete operations are performed on cached data | QueryObject |
DBDelete ([rownumber = integer] [,isrepeated = integer] [,zerorowsiserror = integer] [,maxrows = integer]) | integer | Deletes rows from database tables when the rows contain columns for which the IsDeleteWhere attribute has been set to TRUE | QueryObject |
DBInsert ([rownumber = integer] [,isrepeated = integer] [,zerorowsiserror = integer] [,maxrows = integer]) | integer | Performs inserts on database tables with columns mapped to variables or fields specified for insertion | QueryObject |
DBUpdate ([rownumber = integer] [,isrepeated = integer] [,zerorowsiserror = integer] [,maxrows = integer]) | integer | Performs updates on database tables with columns mapped to variables or fields specified for update | QueryObject |
Duplicate() | RowCross | Makes a duplicate of the object, placing a reference to the new object in a reference variable | Object |
FetchRow (rowindex = integer) | integer | Seeks an arbitrary row in the cache | DataStream |
GetAttribute (attributename = byref(variable) {,attributename = byref(variable)}) | integer | Gets the values of any number of attributes for the object | Object |
IsA (class = classname) | integer | Returns TRUE if the object is of the same class as, or one of the subclasses of, the class specified by classname | Object |
Load() | integer | Moves data into target variables, objects, or fields on the frame | DataStream |
NextRow() | integer | Retrieves the next row of data from the database into internal buffers | DataStream |
Open (querymode = integer, [scope = CompositeScope] [,checkcols = integer, isrepeated = integer], [maxrows = integer]) | integer | Opens the query with the semantics implied by the specified mode | DataStream |
PrevRow() | integer | Backs up to the previous row in the cached sequence and positions that row to be loaded into fields or variables | DataStream |
SetAttribute (attributename = value {,attributename = value}) | integer | Sets any number of attributes for the object | Object |
SetCols ([scope = CompositeScope]) | integer | Checks the query for syntactic errors and initializes the array | DataStream |