Master/Detail and OnNewRecord

cis-wurzen · Post by **cis-wurzen** » Fri 09 Sep 2005 14:53

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

Alex · Post by **Alex** » Mon 12 Sep 2005 08:02

We couldn't reproduce the problem.
Please send us complete sample to demonstrate it and include script to create server objects.

cis-wurzen · Post by **cis-wurzen** » Mon 12 Sep 2005 10:31

I've just sent the mail with sample code to Dmitry.

Alex · Post by **Alex** » Mon 12 Sep 2005 14:38

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.