SQLConnection.ODBCCursors Property

A constant representing the cursor type for the SQL connection.

Namespace: VO
Assembly: VOSQLClasses (in VOSQLClasses.dll) Version: 2.19

Syntax

 VIRTUAL PROPERTY ODBCCursors AS USUAL GET SET

public virtual Usual ODBCCursors { get; set; }

Type: Usual
A constant representing the cursor type for the SQL connection.

Remarks

Tip
The cursor type can only be changed if the current connection is not busy. If an invalid value is specified, the cursor type remains unchanged.

Possible values include: SQL_CUR_USE_IF NEEDED (default for most drivers) SQL_CUR_USE_ODBC SQL_CUR_USE_DRIVER

Tip
Refer to your ODBC documentation for a description of these constants.

Tip
Please note that the default for this option has changed from SQL_CUR_USE_ODBC in the past to SQL_CUR_USE_IF NEEDED in the latest versions of X#.