Error in RefreshRecord When use a VIEW in TableName !

b_yaghobi · Post by **b_yaghobi** » Sat 13 May 2006 10:33

Hi,

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

Guest · Post by **Guest** » Sat 13 May 2006 10:42

Error : "Refresh failed. Found 0 records."

Jackson · 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.

b_yaghobi · Post by **b_yaghobi** » Tue 16 May 2006 06:59

Tanks Core Lab Team