Background documentation-10505: Result set type is UPDATABLE but row set type is READ_ONLY Locate this document in the navigation structure

 

Explanation

A RowSet could not be generated, because the corresponding SQL statement or the result set type does not allow updates (modifications).

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 sing the SQLDBC_Statement::ConcurrencyType or SQLDBC_PreparedStatement::ConcurrencyType method.