Error in RefreshRecord When use a VIEW in TableName !

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

Error in RefreshRecord When use a VIEW in TableName !

Post by b_yaghobi » Sat 13 May 2006 10:33


When i use a View in TableName property (not original table) then use
RefreshRecord raise error !


Post by Guest » Sat 13 May 2006 10:42

Error : "Refresh failed. Found 0 records."

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Mon 15 May 2006 15:08

TCustomDADataSet raises this exception when RefreshRecord procedure returns 0 or more than 1 record.
You can turn off this message. Please refer to help TCustomMyDataSet.Options.StrictUpdate.
This situation also may occur if your query doesn't contain key fields and SDAC generates incorrect refresh query. You can manually specify SQLRefresh which will be used for refreshing data. You can also set property TCustomMSDataSet.Options.FullRefresh to True. If FullRefresh property is True, all fields from query are included into SQL statement to refresh single record. For more information about this property please refer to help TCustomMSDataSet.Options.FullRefresh.

Posts: 12
Joined: Tue 16 May 2006 06:55
Location: Iran-Tehran

Post by b_yaghobi » Tue 16 May 2006 06:59

Tanks Core Lab Team

Post Reply