BorlandTalk.com

Mark Thorogood · Guest

Hi All

Delphi 7.0 Enterprise
Access 2000
MDAC 2.70

I use the very useful TBetterADODataSet ADO component for much of my ADO
database work and I am trying to implement refreshing just the current
record, which the component caters for via setting its RefreshType property
to rtResyncCurrent. This works as expected for client based cursors however
for a server based KeySet cursor I keep getting the error "Current Provider
does not support refreshing underlying values". This is NOT a problem with
just TBetterADODataSet it occurs with TADODataSet if you do a
ADODataSet1.Recordset.Resync(adAffectCurrent, adResyncAllValues);

This seems very silly as by the nature of a server based keyset cursor the
values are updated in DB bound controls automatically as you navigate
through the DataSet. So you would have thought that there must be a simple
method to update DB bound controls without navigating to another record and
back.

Anybody else experienced this, has any possibly solutions or reasons for
problem?

Thanks in advance

Mark Thorogood - Thorogood Software Limited

Vassil Nazarov · Guest

The Recordset.Resync method is implemented by the ADO's
cursor engine and is therefore only available with client cursors.

HTH
--
Vassil Nazarov
http://betterado.hit.bg/

Mark Thorogood · Guest

Hi

Thanks for the response. Any suggestions of how to achieve what I'm looking
for? I know I could do a requery or navigate away and return to current
record but those solutions have various overheads associated with them.

Regards

Mark Thorogood

"Vassil Nazarov" <vassil (AT) engineer (DOT) bg> wrote