-10506: Result set type is READ_ONLY but row set type is UPDATABLE


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

User Action:

Result sets that cannot be modified can only be generated using special SELECT statements.

The following options are available:

·        Alter the SQL statement

·        Set the result set type to CONCUR_READONLY using the SQLDBC_Statement::ConcurrencyType or SQLDBC_PreparedStatement::ConcurrencyType method. This generates a read-only result set.