Setting a statement attribute for an ODBC cursorΒΆ
sql_set_stmt_attr() |
Set a statement attribute for an ODBC cursor |
SYNTAX
sql_set_stmt_attr(cursor_id, attr_id, value)
Set a statement attribute for an ODBC cursor. This function is for advanced use with the sql command. It maps directly to the Microsoft ODBC function SQLSetStmtAttr() and programmers should refer to that for further documentation.
The following useful attributes are defined in sculptor.h, together with values for use with SQL_ATTR_CURSOR_TYPE and SQL_ATTR_CONCURRENCY :
SQL_ATTR_QUERY_TIMEOUT |
|
SQL_ATTR_MAX_ROWS |
|
SQL_ATTR_NOSCAN |
|
SQL_ATTR_MAX_LENGTH |
|
SQL_ATTR_CURSOR_TYPE |
SQL_CURSOR_FORWARD_ONLY
SQL_CURSOR_KEYSET_DRIVEN
SQL_CURSOR_DYNAMIC
SQL_CURSOR_STATIC
|
SQL_ATTR_CONCURRENCY |
SQL_CONCUR_READ_ONLY
SQL_CONCUR_LOCK
SQL_CONCUR_ROWVER
SQL_CONCUR_VALUES
|
SQL_ATTR_KEYSET_SIZE |
|
SQL_ATTR_ROWSET_SIZE |
|
SQL_ATTR_SIMULATE_CURSOR |
RELATED TOPICS |