Gets column information for the specified result set column.
sqlany_get_column_info ( $stmt, $col_index )
$stmt A statement object that was executed by sqlany_execute or sqlany_execute_direct.
$col_index The column number between 0 and sqlany_num_cols() - 1.
Returns a 9-element array of information describing a column in a result set. The first element contains 1 on success or 0 on failure. The array elements are described in the following table.
Element number | Type | Description |
---|---|---|
0 | Integer | 1 on success or 0 on failure. |
1 | Integer | Column index (0 to sqlany_num_cols() - 1). |
2 | String | Column name. |
3 | Integer | Column type. See Column types. |
4 | Integer | Column native type. See Native column types. |
5 | Integer | Column precision (for numeric types). |
6 | Integer | Column scale (for numeric types). |
7 | Integer | Column size. |
8 | Integer | Column nullable (1=nullable, 0=not nullable). |
# Get column info for first column (0) rc, col_num, col_name, col_type, col_native_type, col_precision, col_scale, col_size, col_nullable = api.sqlany_get_column_info( stmt, 0 ) |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |