SqlSetStmtCursorType Function | |
Return and optionally change the default cursor type used by for SQLSelect objects
Namespace:
VOSQLClasses
Assembly:
VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
Syntax FUNCTION SqlSetStmtCursorType(
nNew
) AS LONG CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })]
public static int SqlSetStmtCursorType(
Usual nNew = default
)
Request Example
View SourceParameters
- nNew (Optional)
- Type: Usual
The default concurrency strategy that will be used by new SqlSelect objects
Return Value
Type:
Long
If
nNew is not specified, SQLSetStmtCursorType() returns the current setting.
If
nNew is specified, the new setting is returned.
Remarks
The concurrency mode for SQLSelect objects is used to determine if rows have been changed by other connections. The possible values are:
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 used by X# is SQL_CURSOR_KEYSET_DRIVEN
Examples See Also