Try like this:
Its in macro:
set vDisplayCd = ActiveDocument.Variables("vDisplayCd")
NewDisplayCd = vDisplayCd.GetContent.String
Set Result= ActiveDocument.DynamicUpdateCommand("UPDATE * SET FISC_YR_QTR_DSPLY_CD="&NewDisplayCd&" WHERE FieldName='Condition'")
if Result = false then
But why you used update in qlikview? you can use in database, then you will use that table here?? That gives more performance rather than this, i think so...
For more details:
Hope it helps;
I am trying to update the stats on the table to improve query performance. I am not doing this on the database as this is a volatile table that is created in the Qlikview script itself.
I am not sure what your macro is achieving, but it looks like it is would update fields within the table. I want to ensure my queries compile with up-to-date statistics on the volatile table.