Show TOC

-10505: Result set type is UPDATABLE but row set type is READ_ONLYLocate this document in the navigation structure

Use

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.