damex_getFirstCol
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
This method navigates through the columns that appear in the SELECT, UPDATE and WHERE clause of the SQL query or through the columns 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.
long damex_getFirstCol(
long hTable,
int iColType)
Parameters for damex_getFirstCol
| Parameter | Type | Description |
| INPUT | ||
| hTable | long | 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 | ||
| long | The handle to the first column that has the attributes of iColType. A 0 otherwise. | |