SQLSetStmtOption (Visual FoxPro ODBC Driver)

  • Article

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.