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@...>
To: <IBObjects@yahoogroups.com>
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/
>
>
>