Page 1 of 1
Error in RefreshRecord When use a VIEW in TableName !
Posted: Sat 13 May 2006 10:33
by b_yaghobi
Hi,
When i use a View in TableName property (not original table) then use
RefreshRecord raise error !
Posted: Sat 13 May 2006 10:42
by Guest
Error : "Refresh failed. Found 0 records."
Posted: Mon 15 May 2006 15:08
by Jackson
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.
Posted: Tue 16 May 2006 06:59
by b_yaghobi
Tanks Core Lab Team