Refresh problems

Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
Post Reply
capetto
Posts: 5
Joined: Fri 27 Mar 2009 15:14

Refresh problems

Post by capetto » Mon 06 Jul 2015 13:00

Hello,
I'm trying the version 1.1.83. In my SQL Server table there is one trigger that modify (on row update) a column value. When I commit an update operation this value is correctly updated in the DB but not in Excel (refresh problem?). The value is correctly displayed when I press the "Refresh" button. This problem does not appears with an insert trigger.

Thank you, Luca

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Refresh problems

Post by Pinturiccio » Tue 07 Jul 2015 16:11

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Refresh problems

Post by Pinturiccio » Mon 13 Jul 2015 14:20

We have added the new check box "Refresh all columns after commit" for refreshing data after commit to Options -> Edit -> General. It is selected by default. We will post here when the corresponding build of Excel Add-ins is available for download.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Refresh problems

Post by Pinturiccio » Thu 27 Aug 2015 09:25

New version of Devart Excel Add-ins 1.2 is released.
It can be downloaded from http://www.devart.com/excel-addins/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=32345

Post Reply