--- In IBObjects@yahoogroups.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