Ok, I will create sample and send it to jwharton@....

Earnest Tse

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> I will need a sample application with stock components only which
> demonstrates the problem. Then, I should be able to put a solution
together
> much faster.
>
> Thanks,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> -- We may not have it all together --
> -- But together we have it all --
>
>
> ----- Original Message -----
> From: "earnesttse" <earnesttse@y...>
> To: <IBObjects@y...>
> Sent: Thursday, November 21, 2002 9:11 PM
> Subject: [IBO] Question about Master-Detail-Detail of TIBOQuery
>
>
> > Hello,
> >
> > I have problems when I try to use Master-Detail1-Detail2 with
> > TIBOQuery:
> >
> > 1. In CachedUpdate mode: The records of detail2 can't be saved.
> >
> > If the detail2 is in CachedUpdate mode, all data will be ingored
> > after
> > applying ApplyUpdates and CommitUpdates. If the detail2 is not in
> > CachedUpdate mode, everything works fine.
> >
> > 2. The content of Detail2 don't change when moves to another
record
> > of
> > Detail1:
> > This problem only happened when Detail1 is empty. I can repeat
the
> > problem
> > by following steps:
> >
> > a. Insert a record in Detail1
> > b. Insert records in Detail2
> > c. Insert another record in Detail1
> > d. You see the detail of first record of Detail1 still be showed.
> >
> > If the detail1 is not empty or in borowse mode, there is no
problem.
> >
> >
> > * I am using Delphi 6 Enterprise with update 2, IBObject 4.2Ib
and
> > wwDBGrid
> > of IP3000.
> >
> > SQL of Master: Select StockCode from Stock Order by StockCode;
> >
> > SQL of Detail1: Select StockCode, Color, PSize from StockPrice
where
> > StockCode=:StockCode Order by StockCode, Color, PSize;
> >
> > Datasource of Detail1: dsMaster
> >
> > SQL of Detail2: Select StockCode, Color, PSize, Location, Qty
from
> > StockLoc
> > where StockCode=:StockCode and Color=:Color and PSize=:PSize
Order by
> > StockCode, Color, PSize, Location;
> >
> > Datasource of Detail2: dsDetail1
> >
> > Thanks for help!
> >
> > Earnest
> >
> >
> >
> >
> >
> >
>
_____________________________________________________________________
______
> > IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> > without the need for BDE, ODBC or any other layer.
> >
>
_____________________________________________________________________
______
> > http://www.ibobjects.com - your IBO community resource for Tech
Info
> papers,
> > keyword-searchable FAQ, community code contributions and more !
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >