I have developed a client/server application that uses a mySQL database as the database on the server. Now the app that will access the server will also have a database that will store the local data. For that I used a firebird database.
Now the app must update the local database, with records from the mySQL database, say once a day. Now the problem is, that I need to also change the record in the mySQL as soon as it has updated the firebird database, but when I want the app runs and I click the update button, I get the following error and no data gets updated to the firebird database as well:
database.exe raised exception class EDatabaseError with message 'tbStudent: Cannot modify a
read-only dataset'.
At the moment I'm running the mySQL via XAMMP on my localhost, and the firebird is also running on localhost. I'm developing with Delphi XE2
Edit: Sorry guys, it seems the question was not clear. For my mySQL connection I'm using the standard TSQLConnection, and TSQLTable components, and the queries uses TSQLQuery. So when I try and access the mySQL database with a TGrid for example, it gives me action is not allowed for unidirectional datasets. I cannot write to the TSQLTable, as it gives me the read-only dataset error. I tried looking at the components and there is no place to change them from read only to also grant write access. That is what I'm trying to figure out, how to grant write access