topic Dynamic Data Update not working in QlikView

Dynamic Data Update not working

Sun, 19 Feb 2012 10:45:15 GMT

Hi, i am using without success this simple macro in QV 9 to update database:

sub cmdUpdate

SET Result = ActiveDocument.DynamicUpdateCommand ("UPDATE Table SET EQUIP_MODEL_REF = 0 Where LOCATION_DEF = 30001283")

if Result = false then

MsgBox Result.ErrorMessage

end if

end sub

When use the macro it directly opens the module editor but doesn't show error message

Does anyone know what i have to do?

Thanks!

Fri, 24 Feb 2012 10:09:29 GMT

In Document your settings, on the Server tab, make sure the Enable Dynamic Data Update is ticked.

Hope this help.

Andrew

Fri, 24 Feb 2012 19:50:34 GMT

Ok, I didn't know it only works in Server edition.

Thanks