Devart Forums

Hello,

I am testing MyDAC components.
I have a trouble with Master/Details relationship:
The problem is that Primary key is not propagated automaticly
to details.

When I use ADO + MSSQL the key is propagated to details.

How could I solve it ?

More information:

I have created the relationship in TMyQuery using MasterSource
and SQL Query with KEY = :KEY

This code is translated since an app that works very well with ADO + MyODBC.

In TClientDataSet I have linked Master with Detail VIA DataSetField

Regards

It looks like quite uncommon type of master/detail relationship (between two connection types). But we nevertheless tested it. All works fine. Check if you set MasterSource property in MyQuery/MyTable and data type of the KEY. Delphi doesn't allow INT64 or UNSIGNED INT data types for automatic Master-Detail relationship. See MyDAC FAQ for more information.

The relation is OK. I have been tested with ADO and Microolap components and works fine in both. Do you know this problem ?

We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.

Also supply us following information
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor

I sent a mail with project attachment (5 days)
but I have not received any response.

Did you receive the mail ?

Regards

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next MyDAC build. It will be available in about one month. Please watch for announcements at the forum.