SQLSelect.SimulateCursor Property |  |
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.21
SyntaxRequest Example
View Source
A constant, which describes the way the ODBC drivers tries to guarantee that update or delete statements only affect one single row.
Property Value
Type: UsualA 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.
The default value for this property can be set through the function SqlSetStmtSimulateCursor()
| Constant | Description |
|---|---|
| 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 |
 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