CDaoRecordset.AddNew() fails with ODBC Sybase SQL Anywhere
I can't add a new record in a table of a SQL Anywhere Database with
DAO.
I can create new tables and fields. The database and the tables are
updatable. But all fields of all tables have the property
?DataUpdatable = FALSE.
I can open the CDaoRecordset, I can read the values of all fields, but
I can't use the AddNew() method. I get the CDaoException ?Database is
read-only.
The same procedure happens with the Visual Data Manager inside Visual
Basic. When I connect the SQL Anywhere Database via ODBC, the database
and all tables are updatable, but the fields are not. I can navigate
through the records, but I can't use the AddNew or Edit Button.
When I connect a dBase III or MDB Database via ISAM, I can edit the
records.
When I create a CRecordset derived class (not CDaoRecordset) with the
App Wizard and connect this class to a table in the SQL Anywhere
database, I can update the records.
Is it possible to edit the records in a table via DAO?
If yes, where is the mistake?
Thank you for help in advance,
Klaus