I've implemented a class using nested datasets. It nicely handles
much of the work for the detail dataset behind the scenes. When I
edit or append new records, the updates are cascaded correctly.
However, when I delete a master record and apply updates, the
corresponding detail records do not get deleted. I have
poCascadeDeletes and poCascadeUpdates turned on in my data provider.
When I delete a master record, should I expect the corresponding
detail records to be deleted transparently? Or is there some
principle I'm missing?
Also, when all the master records are loaded, does the system
automatically load all the detail records at the same time and then
just apply filters as the current master record changes? It appears
so, since I can edit detail records and I don't lose my changes by
moving to another master record. I'd like to understand the
performance issues for loading a lot of master records.
I have a working demo of nested datasets (ClientDatasets through
SQLDatasets) with nested classes that I'd like to post somewhere for
others to reference. Any suggestions where I could put this?
Thanks.
Jeff