STMTBaseDesc (statement base table descriptor)

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

STMTBaseDesc (statement base table descriptor)

Return to chapter overview

The STMTBaseDesc structure provides basic information about the original columns upon which the result set is based, using the following fields:

Field

Type

Description

szDatabaseName

DBINAME

Specifies the database name.

szTableName

DBITBLNAME

Specifies the table name (no extension or directory).

szFieldName

DBINAME

Specifies the field name.

bExpression

BOOL

When the SQL query has an expression (Select Col1+5...) bExpression is set to TRUE and the field is the first field encountered in the expression. Thus the following SQL: (SelectCol1 + Col2 from ':alias:Table') would return a record looking like "alias  Table Col1  1  0  0".

bConstant

BOOL

When the SQL query has a constant (Select 'test'...) bConstant is set to TRUE and field is the constant value.

bAggregate

BOOL

If the SQL has an aggregate, bAggregate is set to TRUE. The order of the records in the cursor represents the order of the items in the select list.



The following SQL, (Select Col3, Col2, Col1...) would result in a table with the records in this order:  Col3, Col2, Col1.