Devart Forums

Hello!.


I am being tested for MYSQL devart component.
But I have up the next problem:

I created a FORM which has only one SQLConnection1 (DevartMySQL) and SQLDataSet.

Are connected correctly and I can make a query ok.

the problem is that when I do an Update or Insert, I get a window with the following error:
Cannot modify a Read-only dataset

can help me?

Thanks!

I'm using Embarcadero XE2 Update2.

Hello,

The TSQLDataSet standard component is unidirectional, this is a specificity of the dbExpress technology. You can find more information about TSQLDataSet in the RAD Studio XE2 documentation. Here is a quote from it:

TSQLDataSet is a general purpose unidirectional dataset for accessing database information using dbExpress.

To work with data in bidirectional mode, you should use the following chain of components:For more information, please read the "Using dbExpress" and "Using dbExpress Datasets" articles of the RAD Studio XE2 documentation.