Refreshrecord method

Anders Balslev

Delphi Developer

Refreshrecord method

2007-09-30 03:07:21 PM
delphi136
BDS2006
MS SQL Server 2000
I do have a problem using the RefreshRecord method on a ClientDataset
After call toCDS.RefreshRecord, I get the errormessage
"Record not found, No key specified"
The providers update option is "WhereKeyOnly"
and in the providers OnUpdateData event, I set
Dataset.FieldByName('MyID').ProviderFlags := [pfInKey]
('MyID' is the primary key in the database)
Any hint??
Best regards
Anders

Anders Balslev

Delphi Developer

2007-10-05 01:45:11 PM

Re:Refreshrecord method

HI
Are there anything news?
Anders
"Anders Balslev" <XXXX@XXXXX.COM>writes

Quote

BDS2006
MS SQL Server 2000

I do have a problem using the RefreshRecord method on a ClientDataset

After call toCDS.RefreshRecord, I get the errormessage

"Record not found, No key specified"

The providers update option is "WhereKeyOnly"
and in the providers OnUpdateData event, I set

Dataset.FieldByName('MyID').ProviderFlags := [pfInKey]
('MyID' is the primary key in the database)

Any hint??

Best regards

Anders