Click or drag to resize

SQLSelect.SimulateCursor Property

X#
A constant, which describes the way the ODBC drivers tries to guarantee that update or delete statements only affect one single row.

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

Property Value

Type: Usual
A constant, which describes the way the ODBC drivers tries to guarantee that update or delete statements only affect one single row.
Remarks
One of the following constants, which describes the way the ODBC drivers tries to guarantee that update or delete statements only affect one single row.
ConstantDescription
SQL_SC_NON_UNIQUE The driver does not guarantee that simulated positioned update or delete statements will affect only one row; it is the application's responsibility to do so. If a statement affects more than one row, SQLExecute, SQLExecDirect, or SQLSetPos returns SQLSTATE 01001 (Cursor operation conflict).
SQL_SC_TRY_UNIQUE The driver attempts to guarantee that simulated positioned update or delete statements affect only one row. The driver always executes such statements, even if they might affect more than one row, such as when there is no unique key. If a statement affects more than one row, SQLExecute, SQLExecDirect, or SQLSetPos returns SQLSTATE 01001 (Cursor operation conflict).
SQL_SC_UNIQUE The driver guarantees that simulated positioned update or delete statements affect only one row. If the driver cannot guarantee this for a given statement, SQLExecDirect or SQLPrepare returns an error
The default value for this property can be set through the function SqlSetStmtSimulateCursor()
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