Re: Refreshing a current record in a DataSet


Is there possibility to refresh from database in TADOQuery a current record
in dataset, without Open/Close and reloading entire dataset?

Only refreshing single record.

Yes

with ADODataset1 do begin
UpDateCursorPos; {MUST ALWAYS DO!}
RecordSet.Resync(adAffectCurrent, adResyncAllValues);
end;

You will need the Unit AdoInt in your uses to use this code.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages