Sat, 08 Feb 2003 03:00:00 GMT

How to commit Updates to Detail table ?

First you need to break the link between the twos Datasource.  Second don't use
the IBDatabase's ApplyUpdates as there is a bug in multiple updates, do the
master first and then the detail.

Quote
Ken wrote:

> Why  can't I commit updates to Detail table?

> procedure TForm1.BitBtn1Click(Sender: TObject);
> begin
>    IBDatabase1.ApplyUpdates([IBQuery1,IBQuery2]);
> end;

> I used a TIBUpdateSQL for each TIBQuery and Set  TIBQuery 's CachedUpdates
> to True;
> But when I Insert  a record , and then Post them, But Detail Query doesn't
> been saved .
> Why?

> Thanks a lot !

> Ken

--
Jeff Overcash (TeamB)
      (Please do not email me directly unless  asked. Thank You)
Mild mannered supermen are held in kryptonite, and the wise and foolish
{*word*269}s giggle with their bodies glowing bright.  Through the door a harvest
feast is lit by candlelight; it's the bottom of the staircase that spirals out
of sight.
  (new classic Genesis) Carpet Crawlers 1999