Click or drag to resize

SqlSetStmtCursorType Function

X#
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
Request Example View Source

Parameters

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:
ConstantDescription
SQL_CURSOR_FORWARD_ONLYThe cursor only scrolls forward
SQL_CURSOR_KEYSET_DRIVENThe driver saves and uses the keys for the number of rows specified in the SQL_ATTR_KEYSET_SIZE statement attribute
SQL_CURSOR_DYNAMICThe driver saves and uses only the keys for the rows in the rowset.
SQL_CURSOR_STATICThe data in the result set is static
The default value used by X# is SQL_CURSOR_KEYSET_DRIVEN
Examples