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
Syntax VIRTUAL PROPERTY CursorType AS USUAL GET SET
public virtual Usual CursorType { get; set; }
Request Example
View SourceProperty 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:
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 |
The default value for this property can be set through the function SqlSetStmtCursorType()
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