SQL_GET_NUM_COLS¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
This command is used to get the number of columns retrieved from an SQL expression result set. Since the column number is based on the result set, this command cannot be used when the results are being bound to the record buffer. If this command is used with the record buffer or if no columns are found, -1 is returned.
Syntax
SQL_GET_NUM_COLS to {variable}
Parameter |
Description |
|---|---|
variable |
Variable to hold the number of columns. |
Example
SQL_SET_STMT to "SELECT * FROM CUSTOMER WHERE FIRSTNAME = 'Aaron'"
SQL_PREPARE_STMT
SQL_EXECUTE_STMT
GET_RESULT_SET_NUM_COLS to iNumCols
Showln iNumCols