Page 1 of 1

Master/Detail and OnNewRecord

Posted: Fri 09 Sep 2005 14:53
by cis-wurzen
Using latest version of ODAC (5.55.1.22) and Delphi for development.

2 Tables are linked over Master-Detail-Relationship. The Relationship is set with MasterFields, Detailfields and MasterSource.
Everytime i change a Field (any Field) in the master-dataset the detail-dataset is refreshed. If i change 5 fields 5 times a refresh is called.

This means also for each field which is filled in the event OnNewRecord of the master-dataset a refresh of the Detail is done.

This reduces the performance enormous, especially you have many records in the detail-dataset.

I think it's only necessary to refresh the detail-dataset if the masterfield is changed. Can you fix this:?:

TIA

Posted: Mon 12 Sep 2005 08:02
by Alex
We couldn't reproduce the problem.
Please send us complete sample to demonstrate it and include script to create server objects.

Posted: Mon 12 Sep 2005 10:31
by cis-wurzen
:arrow: I've just sent the mail with sample code to Dmitry. :lol:

Posted: Mon 12 Sep 2005 14:38
by Alex
Thank you for your sample. It does help us very much.
We reproduced your problem and fixed it. This fix will be included in the next ODAC build.