Devart Forums

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

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.

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