Discussion Board for collaboration on QlikView Scripting.
I use the following to load some data:
LOAD * INLINE [
I have the following macro's (taken from the QlikView Automation Reference and updated to match the fields):
SET Result = ActiveDocument.DynamicUpdateCommand("UPDATE * SET Beta = 1")
if Result = false then
SET Result = ActiveDocument.DynamicUpdateCommand ("INSERT INTO * (Alpha, Beta) VALUES (x, 0), (y, 0), (z, 0)")
I have a two buttons from which i trigger the Update and Insert macro.
For some reason the values doesn't get updated or inserted. When i trigger one of these macro's the Edit Module opens and the line starting with SET Result .... is highlighted.
Any sugestions on how to resolve this issue?
Check your document properties. On the server-tab the option Enable Dynamic Data Update should be on.
After Checking the option Enable Dynamic Update it is working perfect.