Page 1 of 1

Master-detail with cached update

Posted: Mon 29 Jan 2007 09:50
by voicu_oncu
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.

Posted: Tue 30 Jan 2007 14:07
by Alex
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.