Have a bit of a strange problem, wouldn't be an issue but some users 'need' to work on thousands of records in one grid.
Have an OracleDataset, linked to a ClientDataset via a DatasetProvider. Which works fine. The problem arises when I try to refresh one record on the clientdataset (clientdataset1.refreshrecord) as while this does refresh just one record in the clientdataset it requeries all records in the OracleDataset.
This can be seen through OracleMonitor, or by putting a showmessage on the OracleDataset's AfterFetchRecord event.
Is there any way of preventing the Oracle Dataset from querying all records so we can refresh just the one?
(Delphi 6, DOA 4.0.6)