--- In IBObjects@yahoogroups.com, "Dmitriy A. Beloshistov" <torin@...>
wrote:

>
> 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]
>

Hi, Dimitry!

Now aliases are different in master and detail, but it doesn't matter,
after opening both tables, skipping to the second record record in
master, detail seems to loose connection with master datasource.

Thank you!

Antonio.