Subject | TIBOQuery, TDataSetProvider, no-longer able to apply updates with Master-Detail |
---|---|
Author | Ashley |
Post date | 2008-11-27T18:10:19Z |
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?
Best regards
ashley
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?
Best regards
ashley