Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Data Update not working

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!

2 Replies
Not applicable
Author

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

Hope this help.

Andrew

Not applicable
Author

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

Thanks