Subject | Re: [IBO] TIBOQuery, TDataSetProvider, no-longer able to apply updates with Master-Detail |
---|---|
Author | Helen Borrie |
Post date | 2008-11-27T22:08:02Z |
At 05:10 AM 28/11/2008, you wrote:
Helen
>Hi thereAre you still using Delphi 5 and the same database engine version as before?
>
>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?
Helen