SQLSetStmtOption

Support: Full
ODBC API Conformance: Level 1

Sets options related to a statement handle, hstmt.

*fOption*	Allowed values	Comments
SQL_ASYNC_ENABLE	SQL_ASYNC_ENABLE_OFF	If you attempt to set this fOption, the driver returns the error: "Driver not capable". Visual FoxPro does not support asynchronous execution.
SQL_BIND_TYPE	SQL_BIND_BY_COLUMN or a 32-bit value denoting the length of the structure or an instance of a buffer into which result columns will be bound.
SQL_CONCURRENCY	SQL_CONCUR_READ_ONLY SQL_CONCUR_LOCK SQL_CONCUR_VALUES	The driver doesn't allow SQL_CONCUR_ROWVER, because Visual FoxPro does not have row versioning based on timestamps.
SQL_CURSOR_TYPE	SQL_CURSOR_FORWARD_ONLY SQL_CURSOR_STATIC	The driver does not allow SQL_CURSOR_KEYSET_DRIVEN or SQL_CURSOR_DYNAMIC; see SQLSetScrollOptions for more information.
SQL_KEYSET_SIZE	Error: "Driver not capable"	Visual FoxPro does not support the keyset cursor model.
SQL_MAX_LENGTH	0	If you attempt to set this fOption value, the driver returns the error "Driver not capable".
SQL_MAX_ROWS	0	If you attempt to set this fOption value, the driver returns the error "Driver not capable".
SQL_NOSCAN	SQL_NOSCAN_OFF
SQL_QUERY_TIMEOUT	0	If you attempt to set this fOption value, the driver returns the error "Driver not capable".
SQL_RETRIEVE_DATA	SQL_RD_ON, SQL_RD_OFF
SQL_ROWSET_SIZE	1 to 4,294,967,296
SQL_SIMULATE_CURSOR	Error: "Driver not capable"
SQL_USE_BOOKMARKS	SQL_UB_OFF SQL_UB_ON

For more information, see SQLSetStmtOption in the ODBC Programmer's Reference.