Hello, Antonio!



Try rename table alias in master or detail SQL from "M" to any another name. I.e. aliases must be with different names.





WBR, Dmitry Beloshistov AKA [-=BDS=-]







From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Antonio Carlos Ribeiro
Sent: Wednesday, February 04, 2009 5:30 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: TIBOQuery Master-Detail isn't working anymore

--- In IBObjects@yahoogroups.com <mailto:IBObjects%40yahoogroups.com> , Helen Borrie <helebor@...> wrote:
>
> At 09:42 AM 4/02/2009, you wrote:
> >Update:
> >
> >// Q1 is Master (TIBOQuery) - dsQ1 the DataSource (TDataSource) of Q1
> >// Q2 is Detail (TIBOQuery)
> >
> >Q2.DataSource := dsQ1;
> >Q1.Open;
> >Q2.Open;
> >// == Master and detail are synchronized
> >
> >Q1.Next;
> >// == Detail remains opened but with RecordCount = 0
> >
> >Q2.Close;
> >Q2.Open;
> >// == Detail gets synchronized with Master - RecordCount = 1
> >
> >As I said, just updated from 4.6 to 4.8.
> >
> >Any ideas?
>
> Show the SQL for both the master set and the detail set. Not yards
of code, please, just the SQL.
>
> Helen
>

// ------------ Master
SELECT
M.*
FROM L_MATERIAL M
ORDER BY M.CODIGO_MATERIAL

// ------------ Detail
SELECT
M.*
FROM L_ENTRADA_MATERIAL M
WHERE M.CODIGO_MATERIAL = :CODIGO_MATERIAL
ORDER BY M.CODIGO_ENTRADA_MATERIAL DESC

Thank you,

Antonio





[Non-text portions of this message have been removed]