Problem with master detail

Edison Garcia · Post by **Edison Garcia** » Thu 22 Feb 2007 23:00

I am having problems with the following situation:( Delphi 7)
3 MyQueries: QA, Qb and QC
QA has no setting of mastersource etc... and has a "Where" condition over field named Item
QB has a mastersource indicating QA, and Master field relation:
QA field Item = QB field AItem
QC uses QB as master source, and indicates as master fields
QB field AItem = QC field ACTItem and more
QB field AEmp = QC field ACTEmp
(I hope you could undestand it) but the fact is that it works beautifully except in one condition:
if it occurs that there are no records in QC that atends to the relation with QB, it also does not show the record in QB that exists. If I remove the ralation between QB and QC, the record in QB is presented.
If you could undesrstand my explanation ( and my english) I would be very happy to receive an answer.
Edison Garcia

Antaeus · Post by **Antaeus** » Fri 23 Feb 2007 09:03

Thank you for information. I modified the MasterDetail demo of MyDAC and used it to test this issue, but I could not reproduce the problem. Please send me a complete small sample at evgeniyD*crlab*com to demonstrate it, including script to create and fill tables.

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

Edison Garcia · Post by **Edison Garcia** » Fri 23 Feb 2007 12:50

Dear Antaeus
thank you for your fast answer and sorry for the waste of time.
The problem was not with myDac . I tried to do the same using DBGrids and it works perfectly. The problem was in the report side.

Thank you
Edison Garcia