.gif) Note |
|---|
|
This topic contains Visual FoxPro ODBC Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.
|
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.