Using latest version of ODAC and Delphi 2005 for development. Converting from BDE.
We have 8 tables that are linked master/detail relationship. When we want to insert records to table 2 and all the table downwards we reset the master source on the 2 table (i.e table2.mastersource=2). The second table has around 100,000 records. With ODAC when we reset mastersource it tries to open table2 again and it takes a long time to load records. Is there anyway to insert record without reopening the table again. We were able to do this with Delphi 6 & BDE.
Thanks,