topic DynamicUpdateCommand don't work in QlikView

DynamicUpdateCommand don't work

Wed, 13 Jan 2010 09:38:49 GMT

Hi,

I have report where in macro is used DynamicUpdateCommand

for i=0 to 3
 if Teams(i,1)>0 then
 sSQL="update [Standings A] set Points = "&Teams(i,1)&" where Team_ID = '"&Teams(i,0)&"'"
 ''msgbox(sSQL)
 set UpdateAction = ActiveDocument.DynamicUpdateCommand (sSQL)
 end if
 next

When I run this macro (on button press) macro edit windows appear with this line selected and there is no error messages. On 2 other computers this macro works fine.

I found that there is parameter 'Enable Dynamic Data Update', but it's checked on all computers

What else can be wrong?

BR, Andris

DynamicUpdateCommand don't work

Wed, 13 Jan 2010 10:02:01 GMT

i guess the only wrong thing is your operating system....

DynamicUpdateCommand just fails on windows vista, server 2008 and very probably seven

DynamicUpdateCommand don't work

Wed, 13 Jan 2010 10:14:35 GMT

OS is XP on all computers

DynamicUpdateCommand don't work

Thu, 14 Jan 2010 10:37:29 GMT

DynamicUpdateCommand is working perfect on Windows 7. Don't known about vista and 2008.

Ramunas

DynamicUpdateCommand don't work

Tue, 20 Jul 2010 08:21:00 GMT

I've seen one post that mentions the need to tick the "Enable Dynamic Data Update" check box on the Document properties' Server tab.

I'm trying to do this just in Developer, and ticking this doesn't work for me yet, but it did get me past the error you were expereincing.

DynamicUpdateCommand don't work

marcel_olmo — Mon, 17 Jan 2011 16:10:22 GMT

Hey John I've got stuck with this stuff the whole day. Thanks for your useful reply.

I've uploaded an image about where to find the check button you need to click in the server tab of the document properties :