I'm using MySQL using the following arrangement:-
TSQLConnection -> TSQLTable1 -> TdatasetProvider1 -> TClientDataset1 -> TDatasource1
TSQLConnection -> TSQLTable2 -> TdatasetProvider2 -> TClientDataset2 -> TDatasource2
...to display, update, and edit records using the standard TDBGrid, TDBEdit components. This all works fine, but if I want to maintain two different views onto the same table (as shown) and I update one of them, the data is not reflected in the other one until I restart the app.
I am using Post followed by Applyupdates(0).