Re: Refreshing a current record in a DataSet



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

I does not actually work the way i expect.

I open ADODataset.
then change some current field valuein database and
do
UpDateCursorPos; {MUST ALWAYS DO!}
RecordSet.Resync(adAffectCurrent, adResyncAllValues);

on client. but nothing seems to change.


Any ideas are welcome.
Does your Query use a Join?
If that is the case you need to set the Resync Command property so that ADO
knows how to query for the updated values.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprodynresynccommand.asp
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages