Master/detail memory

marilyn.works · Post by **marilyn.works** » Thu 22 Dec 2011 11:27

I have master detail TOraQuery datasets on server. Master is Opened on the client side, records are shown, master dataset is closed on server, but detail dataset remains open. It leads to problem with refreshing the detail record an consumes memory that is useless. Provider is TOraProvider and on client side I use TClientDataset. Also master/detail relationship is through MasterSource and parameter.

I wold like detail dataset be closed.

AndreyZ · Post by **AndreyZ** » Mon 26 Dec 2011 09:28

Hello,

ODAC doesn't close the detail dataset if the master dataset was closed. To solve the problem, you should close the detail dataset before closing the master dataset. You can use the AfterClose event handler of the master dataset to close all detail datasets.