Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

DynamicUpdateCommand don't work

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

5 Replies
Not applicable
Author

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

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

Not applicable
Author

OS is XP on all computers

Not applicable
Author

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

Ramunas

Not applicable
Author

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.

marcel_olmo
Partner
Partner

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 :