Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

2 Replies
Anonymous
Not applicable
Author

just quick addtion

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

partenope
Partner - Creator II
Partner - Creator II

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!