Master/Detail

anglam62 · Post by **anglam62** » Mon 16 Jul 2007 11:12

Hi all,
Is it Possible to use the the componet MyQuery instead of SqlQuery(dbExpress)
in the tipical configuration of Master/Detail with one DataSetProvider (link to ClientDataSet-Master) and ClientDataSet-Detail
link to the Master through the dataSetField. I tried this, Configuring Relation
Master/Detail on Component MyQuery-Detail.
It run Good reading Data Master/Detail, but in Insert mode it don't assign
the MasterField on the detail.
tnx, bye.

Antaeus · Post by **Antaeus** » Mon 16 Jul 2007 15:03

I tried to reproduce the problem using your description, but created application works fine for me. When I insert a record in ClientDataSet-Detail, it obtains the correct value for the master field. Applying updates also does not cause any problems.

Please send me a complete small sample at evgeniyD*crlab*com to demonstrate it, including script to create and fill table.

Also supply me the following information:
- exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- exact version of your IDE (including personality name for Delphi 2005, and BDS 2006);
- exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor.

anglam62 · Post by **anglam62** » Mon 16 Jul 2007 21:14

Hi,
So, it's Possible to use the the componet MyQuery
with ClientDataSet in Master/Detail. It is usefull.
I sent all, how you said.
Thanks.
Angelo.

Antaeus · Post by **Antaeus** » Wed 18 Jul 2007 12:02

Thank you for your example.
I could not reproduce the problem using the last build of MyDAC 4.
Try to download the last version of MyDAC and test it. It is 4.40.0.25.

Do not forget to uninstall your current MyDAC.

anglam62 · Post by **anglam62** » Thu 19 Jul 2007 06:52

hi Antaeus,
I try it. All is ok!
So i need last version.

Excuse me for my ignorance, what's the difference from

Professional Edition
Full power of MyDAC data access

and

Developer Edition
All-inclusive MySQL development package

Thanks,
Angelo.

Antaeus · Post by **Antaeus** » Thu 19 Jul 2007 09:09

MyDAC Developer Edition includes MySQL Developer Tools.
You can read more about MyDAC Editions in the MyDAC Editions topic at MyDAC home page.