Attribute | Data Type | Description | Inherited From |
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 |
CurBreakLevel | smallint | Contains the value of the current break level (R) | DataStream |
CurRow | integer | Provides the row number of the currently retrieved row of the query (R) | DataStream |
DBSession | DBSessionObject | Represents the database session created when the SQLSelect object was last opened (R) | Defined |
ErrorNo | integer | Provides the error number of the last operation (R) | DataStream |
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 |
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 (RW) | Defined |
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) | Defined |
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 |
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 |
Duplicate() | SQLSelect | 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 |