Click or drag to resize

SQLSelect.ScrollConcurrency Property

X#
A constant, which describes the concurrency mode used by the SQL statement:

Namespace:  VO
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
Syntax
Copy
 VIRTUAL PROPERTY ScrollConcurrency AS USUAL GET SET
Request Example View Source

Property Value

Type: Usual
A constant, which describes the concurrency mode used by the SQL statement:
Remarks

One of the following constants, which describes the concurrency mode used by the SQL statement:

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 for this property can be set through the function SqlSetStmtConcurrency()
Tip 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