Questions about Tuniquery.option.fullrefresh

wjzws · Post by **wjzws** » Sat 17 Jul 2010 04:40

Hello, I am using version is 3.10, got a question:
Features of option.fullrefresh Tuniquery, if the refresh fails, what happens? there is an error tips? Because tuniquery.options.fullrefresh is running in the background.
I seem to have had, was not refreshed from the data, but the program does not have any hints.

Tuniquery.option.fullrefresh and Tuniquery.refreshrecord function in effect is the same?

As if in the event that no Refresh failed events, you can control. I wonder if this could increase the "onrefresherror" ?

Thank you. Your this great product!

bork · Post by **bork** » Mon 19 Jul 2010 10:05

Hello

To reproduce your issue we need more information:
- What database are you using?
- The SQL query that you are executing and trying to refresh
- DDL script for creating the tables that are used in your query
- Which method do you call to refresh your dataset: Refresh or RefreshRecord
- What does it mean: refresh fails? Please provide us more detailed description.

The Options.FullRefresh option has effect on the RefreshRecord method only. This option doesn't have any effect on the Refresh method.

wjzws · Post by **wjzws** » Tue 20 Jul 2010 02:10

How do you do:
My database is Sqlserver2008
My question is:
If you set Tuniquery.options.fullrefresh:=true ;
　　　　 Tuniquery.refreshoptions.roafterinsert:=true;
Tuniquery.refreshoptions.roafterupdate:=true;

So, the action is automatically refreshed. After performing the refresh Tuniquery.post. But there was not refreshed if a refresh an error?, in which a mistake to see this information? For example: onRefreshError?

Dimon · Post by **Dimon** » Wed 21 Jul 2010 13:59

In on refreshing record an error is raised you can use the try..except block to process the exception.
For example:

Code: Select all

  try
    UniQuery.Post;
  except
    on E: EUniError do
      ShowMessage('Error Message: ' + E.Message);
  end;