SQLColumnType - cSQLStatement
Returns the native type of a column in a result set
Type: Function
Return Data Type: Integer
Parameters
| Parameter | Type | Description |
|---|---|---|
| iCol | Integer | Column number |
Syntax
Function SQLColumnType Integer iCol Returns Integer
Call Example
Get SQLColumnType iCol to IntegerVariable
Description
Returns the native type of a column in a result set.
Possible value are:
| Constant | Meaning |
|---|---|
| SQL_UNKNOWN_TYPE | 0 |
| SQL_CHAR | 1 |
| SQL_NUMERIC | 2 |
| SQL_DECIMAL | 3 |
| SQL_INTEGER | 4 |
| SQL_SMALLINT | 5 |
| SQL_FLOAT | 6 |
| SQL_REAL | 7 |
| SQL_DOUBLE | 8 |
| SQL_DATETIME | 9 |
| SQL_VARCHAR | 12 |
| SQL_TYPE_DATE | 91 |
| SQL_TYPE_TIME | 92 |
| SQL_TYPE_TIMESTAMP | 93 |
Return Value
Native type of a column