Page 1 of 1

Questions about Tuniquery.option.fullrefresh

Posted: Sat 17 Jul 2010 04:40
by wjzws
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!

Posted: Mon 19 Jul 2010 10:05
by bork
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.

My database is Sqlserver2008

Posted: Tue 20 Jul 2010 02:10
by wjzws
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?

Posted: Wed 21 Jul 2010 13:59
by Dimon
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;