|
<< Click to Display Table of Contents >> STMTBaseDesc (statement base table descriptor) |
![]() ![]()
|
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. |