Subject | Re: [IBO] TIBOQuery, TDataSetProvider, no-longer able to apply updates with Master-Detail |
---|---|
Author | Ashley |
Post date | 2008-11-28T07:08:20Z |
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
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
>before?
> 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
>Helen, hi there
> Helen
>
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