Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
just quick addtion
the "damn small" box "Enable Dynamic Data Update" IS checked
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!