Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
vmorozov
New Contributor III

Simple DynamicUpdateCommand test fails

Hi,

here is the test setup:

inputfield flag;

LOAD * INLINE [

id,F1, F2, index,flag

id1,11, 21, 0,0

id2,12, 22, 1,0

id3, 13, 23, 2,0

id4,13,24,3,0

];



sub Update

'SET Result = ActiveDocument.DynamicUpdateCommand ("UPDATE * SET Discount = if(Discount >= 35, 0, if (City='Stockholm', Discount + 5, Discount + 2)) WHERE Country = 'SE'")

SET Result = ActiveDocument.DynamicUpdateCommand ("UPDATE * SET flag = 1") 'stops here selecting the line

if Result = false then

MsgBox Result.ErrorMessage

end if

end sub



Runing the macros doesn't have any effect (i.e. 'flag' field stays unchanged). Actually the macros seems to run until the ActiveDocument.DynamicUpdateCommand line. it stops there selecting the line. During macros debuging, emty message window with 'Ok' button pops up.....

I use the QlikView 9 last update Personal edition

Any suggestions are appreciated

Thanks

vlad

Tags (2)
2 Replies
vmorozov
New Contributor III

Simple DynamicUpdateCommand test fails

just quick addtion

the "damn small" box "Enable Dynamic Data Update" IS checked

Partner
Partner

Simple DynamicUpdateCommand test fails

the "WHERE" clause is mandatory...
The macro fails because the second DynamicUpdate is without WHERE...

The DynamicUpdate functionality seems to be a beta (or alpha) feature! lot of bugs and, in my case, not works on Windows 7!!!

see you!