Hi All, I have a file with text boxes having Dynamic Update action which works great on my system. But the updates stop happening after deploying it on the server. I have checked all the options for allowing dynamic update inside the file, as well as the options in server QV Management Console. Does anyone have a clue why this may be happening. Do I require a special license for allowing updates on the server. I'm using QV version 11.20
Thanks for replying Fernando. I am using Internet Explorer and all the properties in the images are enabled. I'm not using a macro, I have a text box with the update statement written in the 'Dynamic Update' action of the text box. It works in the desktop mode and Web view, but not on the server.
Hi Fernando, I realized that my Dynamic update statement has the '>=' condition which does not work on the server.
My statement is:
UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date >= '$(vUserDate)';
= condition works on the server, but <= or >= don't work. I need to use >= , do you know any way to get it working, probably by changing the statement syntax.
Hi, try to separate?
UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date > '$(vUserDate)' or Limit_Date = '$(vUserDate)' ;
separate >= in > or =
would be an option
Hi Fernando, Thanks for the suggestion, but even the separate symbols do not work. I also read here (BI Review: Using Dynamic Updates in QlikView 11) that only the = condition works in dynamic updates. I tested my file with > which updated data in the desktop QV but not on the server.
Why not create vUserDateMinusOne = vUserDate -1 day?
UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date > '$(vUserDateMinusOne)';
BTW, have you verified with a basic test that your Dynamic update actually works on server?
The user has be part of the QlikView administrator group.
the dynamic update requires a high level of permissions for the users to execute it from the web (access point), the user must be in the 'QlikView Administrator' group.