SQLSelect.ScrollConcurrency Property | |
A constant, which describes the concurrency mode used by the SQL statement:
Namespace:
VO
Assembly:
VOSQLClasses (in VOSQLClasses.dll) Version: 2.21
Syntax VIRTUAL PROPERTY ScrollConcurrency AS USUAL GET SET
public virtual Usual ScrollConcurrency { get; set; }
Request Example
View SourceProperty Value
Type:
UsualA 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:
Constant | Description |
---|
SQL_CONCUR_READ_ONLY | Cursor is read-only. No updates are allowed |
SQL_CONCUR_LOCK | Cursor uses the lowest level of locking sufficient to ensure that the row can be updated |
SQL_CONCUR_ROWVER | Cursor uses optimistic concurrency control, comparing row versions such as SQLBase ROWID or Sybase TIMESTAMP |
SQL_CONCUR_VALUES | Cursor uses optimistic concurrency control, comparing values |
The default value for this property can be set through the function SqlSetStmtConcurrency()
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