SQLSetStmtOption (Visual FoxPro ODBC Driver)

Note

This article contains Visual FoxPro ODBC Driver-specific information. For general information about this function, see the appropriate article under ODBC API Reference.

Support

Full.

ODBC API conformance

Level 1.

Remarks

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 doesn't 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 doesn't have row versioning based on timestamps.
SQL_CURSOR_TYPE	SQL_CURSOR_FORWARD_ONLY SQL_CURSOR_STATIC	The driver doesn't allow SQL_CURSOR_KEYSET_DRIVEN or SQL_CURSOR_DYNAMIC; see SQLSetScrollOptions for more information.
SQL_KEYSET_SIZE	Error: Driver not capable	Visual FoxPro doesn't 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 Function in the ODBC Programmer's Reference.