skip to main content
SQL Engine parse tree methods for .NET : SQL pass-through and advanced query methods reference : damex_getFirstCol
 

damex_getFirstCol

This method navigates through the columns that appear in the schema definition of the table. Call this method with the column types to be navigated and then use the damex_getNextCol method to step through the list.
int64 damex_getFirstCol(
int64 hTable,
int iColType)
 
Table 231: Parameters for damex_getFirstCol 
Parameter
Type
Description
IN
 
 
hTable
int64
Table handle
iColType
int
Identifies the column list to navigate; use a bitwise OR ( | ) of the following flags to scan through columns that are in multiple categories:
DAM_COL_IN_SCHEMA – list of all columns as defined in the schema database
DAM_COL_IN_RESULT – list of columns that are part of the result set
DAM_COL_IN_CONDITION – list of columns that are in the WHERE clause
DAM_COL_IN_UPDATE_VAL_EXP – list of all columns that are part of UPDATE value expressions
DAM_COL_IN_USE – list of columns that are either part of the result or are in the WHERE clause
RETURN
 
 
 
int64
The handle to the first column that has the attributes of iColType. A NULL otherwise.

See also 

• damex_getNextCol