Master-Detail relation and "DefaultValues=true"

skiller · Post by **skiller** » Mon 17 Aug 2009 09:29

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

Plash · Post by **Plash** » Tue 18 Aug 2009 06:56

We have fixed this problem. The fix will be included in the next build of ODAC.

skiller · Post by **skiller** » Fri 21 Aug 2009 14:54

Thx, when will the next build of ODAC be released?

Plash · Post by **Plash** » Tue 25 Aug 2009 08:17

We are planning to release the new ODAC build this week.