Click or drag to resize

SqlSetStmtConcurrency Function

X#
Return and optionally change the default concurrency mode for SQLSelect objects

Namespace:  VOSQLClasses
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
Syntax
 FUNCTION SqlSetStmtConcurrency(
	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, SQLSetStmtConcurrency() 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_CONCUR_READ_ONLYCursor is read-only. No updates are allowed
SQL_CONCUR_LOCKCursor uses the lowest level of locking sufficient to ensure that the row can be updated
SQL_CONCUR_ROWVERCursor uses optimistic concurrency control, comparing row versions such as SQLBase ROWID or Sybase TIMESTAMP
SQL_CONCUR_VALUESCursor uses optimistic concurrency control, comparing values
The default value used by X# is SQL_CONCUR_ROWVER
Examples