System Reference Summary : 3. System Classes : ColumnCross Class
 
Share this page                  
ColumnCross Class
ColumnCross Attributes
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
Is 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 name of the database column whose values are represented as the 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 the 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
integer8
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 DB 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-DB 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