Page 1 of 1

Master-Detail relation and "DefaultValues=true"

Posted: Mon 17 Aug 2009 09:29
by skiller
Hi,

I found a problem with Master-Detail relations and "DefaultValues=true" on the Detail Dataset.

If I call "Append" on the Detail Dataset (TOraTable), the foreign key field (which targets the master record) becomes the "DefaultExpression" ('0') and not the Primary Key Value of the master table.

The old BDE Application ignores the DefaultExpression if working with Master-Detail relations. The new detail record foreign key field becomes the corresponding primary key value of the master record.

Of course, I can assign the PK value manually, but then I have to change the code at thousand places. Same for "dropping the default value for foreign key columns".

Regards
sk

Posted: Tue 18 Aug 2009 06:56
by Plash
We have fixed this problem. The fix will be included in the next build of ODAC.

Posted: Fri 21 Aug 2009 14:54
by skiller
Thx, when will the next build of ODAC be released?

Posted: Tue 25 Aug 2009 08:17
by Plash
We are planning to release the new ODAC build this week.