MyDAC and TClientDataSet

MyDAC and TClientDataSet

Postby 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
 

Postby 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
trying
 

Postby 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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby 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 ?
trying
 

Postby 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
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby 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
trying
 

Postby 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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components