Refresh Problem
Hi
I'm working with two TADODataSets. The first one consists of up to 2000
records. The second dataset always consists of one record, which is also
(always) a 'subrecord' of the first DataSet. Everytime the second dataset
is changed, I must update the data in the first dataset for it's records are
displayed in a grid and the record in the second dataset is always contained
in the first dataset.
I do this by calling the first dataset's Refresh method - which results in
very slow application speeds (if the first recordset if greater than 200
records). I tried to keep a bookmark to the record in the FRIST dataset
thats potentially going to be updated (thus the same record thats present in
the second dataset) in the future. Thus, when the record in the FIRST
dataset must be updated, I bookmark the currently selected record, go to the
bookmark of the record that must be updated, update the record and then
return to the bookmark of the originally selected record again. The
problem I have here is that when I return to the originally selected record,
the record is "scrolled to the centre of the grid" (I hope you'll understand
what I mean here). This causes user confusion.
I would appreciate any advice on getting my record-update-speed up to
scratch.
Thank you
Rico
