Background documentation-10509: The statement was not executed with updatable cursor concurrency Locate this document in the navigation structure

 

Explanation

It was not possible to execute the method (insertOneRow, updateRow or deleteRow) that was called from SQLDBC_UpdatableRowSet, because the result set was not modifiable.

User Response

Modifiable result sets can only be generated using special SELECT statements. The following options are available:

  • Alter the SQL statement

  • Set the result set type to CONCUR_UPDATABLE using the SQLDBC_Statement::ConcurrencyType or SQLDBC_PreparedStatement::ConcurrencyType method.