I have the following macro's (taken from the QlikView Automation Reference and updated to match the fields):
sub Update
SET Result = ActiveDocument.DynamicUpdateCommand("UPDATE * SET Beta = 1")
if Result = false then
MsgBox Result.ErrorMessage
end if
end sub
sub Insert
SET Result = ActiveDocument.DynamicUpdateCommand ("INSERT INTO * (Alpha, Beta) VALUES (x, 0), (y, 0), (z, 0)")
if Result = false then
MsgBox Result.ErrorMessage
end if
end sub
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.
