SQLSelect.CursorType Property |  |
A constant, which describes the cursor type used by the SQL statement:
Namespace: VO
Assembly: VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
SyntaxRequest Example
View Source
A constant, which describes the cursor type used by the SQL statement:
Property Value
Type: UsualA constant, which describes the cursor type used by the SQL statement:
Remarks
One of the following constants, which describes the cursor type used by the SQL statement:
The default value for this property can be set through the function SqlSetStmtCursorType()
| Constant | Description |
|---|---|
| SQL_CURSOR_FORWARD_ONLY | The cursor only scrolls forward |
| SQL_CURSOR_KEYSET_DRIVEN | The driver saves and uses the keys for the number of rows specified in the SQL_ATTR_KEYSET_SIZE statement attribute |
| SQL_CURSOR_DYNAMIC | The driver saves and uses only the keys for the rows in the rowset. |
| SQL_CURSOR_STATIC | The data in the result set is static |
 Tip |
|---|
| Please consult the documentation for the ODBC driver you are using to see the effects of this setting on the performance of your application. |
See Also