Subject Re: [IBO] TIBOQuery, TDataSetProvider, no-longer able to apply updates with Master-Detail
Author Ashley
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 05:10 AM 28/11/2008, you wrote:
> >Hi there
> >
> >I have been using D5, IBO version 4.2 Hj and with multi-tier
> >development have many Master-Detail datasets.
> >
> >If I use any newer version of IBO it is no-longer capable of applying
> >updates if there are changes to both the Master and the Detail. If
> >only updates to the master table, or only the detail then it inserts
> >or updates fine.
> >
> >On the server app, using TIBOQuery and TDataSource for master, with
> >multiple TIBOQuery for the detail tables. Then use a single
> >TDataSetProvider to export to the client app. On the client app use a
> >single cds to connect to the Provider, and multiple detail cds's link
> >to the nested datasets with the DataSetField property...
> >
> >This was working fine with IBO 4.2 Hj
> >
> >Has anyone experienced the same?
> >
> >I am investigating options of intervening and manually applying the
> >updates, but can't believe that it if was working, then it should now
> >have to be done manually?
>
> Are you still using Delphi 5 and the same database engine version as
before?
>
> Helen
>

Helen, hi there

Thank you for reply!

Yes, I am still using Delphi 5.

I have tested with both same engine, FB1.5 and also FB2.1
No difference.

Because of limitations on FB1.5 (max table size), I am upgrading the
db to FB2.1, and I therefore have to use a much newer version of IBO.

Best Regards
ashley