Help Center
/
Help Center›AfxNova›CODBCStmt Class

CODBCStmt.SetCursorConcurrencymethod

Sets a SQLUINTEGER value that specifies the cursor concurrency.

DatabasesmethodCODBCStmt.incdocumented

Syntax

FUNCTION SetCursorConcurrency (BYVAL LockType AS SQLUINTEGER) AS SQLRETURN

Parameters

NameDescription
LockTypeThe type of concurrency.
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.

Return value

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

Description

Sets a SQLUINTEGER value that specifies the cursor concurrency.

Reference

  • Include file CODBCStmt.inc
  • Defined in AfxNova/COdbcStmt.inc:1214
  • Documented in Databases/ODBC Classes/CODBCStmt Class.md
  • Topic: CODBCStmt Class