MyDAC and TClientDataSet

trying · Post by **trying** » Sun 12 Feb 2006 16:19

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 ?

trying · Post by **trying** » Sun 12 Feb 2006 19:01

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

Ikar · Post by **Ikar** » Mon 13 Feb 2006 12:30

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.

trying · Post by **trying** » Mon 13 Feb 2006 14:59

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

Ikar · Post by **Ikar** » Tue 14 Feb 2006 07:23

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

trying · Post by **trying** » Fri 17 Feb 2006 09:01

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

Did you receive the mail ?

Regards

Ikar · Post by **Ikar** » Fri 17 Feb 2006 15:38

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.