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