SqlSetStmtConcurrency Function | |
Note: This API is now obsolete.
Return and optionally change the default concurrency mode for SQLSelect objects
Namespace:
XSharp_VOSQLClasses
Assembly:
XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.21
Syntax [ObsoleteAttribute]
FUNCTION SqlSetStmtConcurrency(
nNew
) AS LONG CLIPPER
[ObsoleteAttribute]
[ClipperCallingConventionAttribute(new string[] { ... })]
public static int SqlSetStmtConcurrency(
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, 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:
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 used by X# is SQL_CONCUR_ROWVER
Examples See Also