Devart Forums

I cannot reproduce the problem. Could you send us a complete small sample at sdac*devart*com including script to create server objects? Also specify the following information:
- the exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- the exact version of your IDE;
- the exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.

Values of calculated fields can be edited only in the OnCalcFields event handler.
Why the second method does not work for MySQL? What happens when you try to edit that field? What is the exact version of MyDAC (x.xx.x.xx)?

Try to install the latest version of SQL Server Native Client on the client computer. You can download it by this link.

You should use the IndexFieldNames property for that.

Thank you for information. I could not reproduce the problem. Please, send me a complete small sample to reproduce it at dbxmda*devart*com. If you have a possibility, check this problem with the Windows version of MySQL and with the application built with Kylix, and with MySQL released prior to MySQL 5.0.51a.

Please check whether this problem is reproduced with the latest versions of SDAC.
If it is, specify the exact version of SQL Server and client on the computer where the problem appears.

Please resend the sample to mydac *crlab*com.

Please specify the versions of DbxMda, MySQL server, and Kylix you are using.
Do you use the same MySQL server from both Delphi and Kylix applications?

There is no way to do it automatically. You should call CoInitialize/CoUnInitialize manually in additional threads that use the driver.

The AddWhere method can add conditions only to SELECT statements. Other statement kinds are ignored.

This is a bug of MySQL 5.0.51a. It returns wrong field length. We will try to avoid this problem in the next build of MyDAC.

We have already fixed this problem. This fix will be included in the next build of DbxSda. Thank you for your help.

Try to download and install the latest build of MyDAC (5.50.0.36). This problem should be fixed in it.

There are two ways to implement this. The first way is to define the foreign key in the table with the ON DELETE CASCADE option. The second one is to delete correspondent records in the detail table in the BeforeDelete event handler of the master dataset.

I could not reproduce the problem.
Please send me a complete small sample at mydac*crlab*com to demonstrate it, including script to create and fill table.

Also supply the following information:
- the exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- the exact version of your IDE;
- the exact version of MySQL server and client. You can see it in the Info sheet of TMyConnection Editor.