Master-detail with cached update

voicu_oncu · Post by **voicu_oncu** » Mon 29 Jan 2007 09:50

Is possible to work with master-detail IBCQuerys and cached update?
I try this and master table is saved but detail table is not saved after apply updates and commit even if master key is not modified. I used an object TIBCUpdateSql for master table and another for detail table (with generated SQLs).
If cached update is false, all is ok.
I use an evaluated version of IBDAC 2.0 and Delphi 7.

Many Thanks.

Alex · Post by **Alex** » Tue 30 Jan 2007 14:07

Please set detail IBCQuery.Options.LocalMasterDetail to True.

If problem persists please send us a complete small demo project, that demonstrates this problem with scripts to create server side objects.