Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Hi Jerry, I have verified with a test that dynamic update is working on the server when I use the equality '=' condition. But it doesn't work when I use >,<,>= or <=.
The user is a part of the administrative group. The update you suggested with vUserDateMinusOne still has the > symbol so it will not work for me.
Thanks for the suggestions though.
Hi Malek. In this case the user is in the administrators group. The dynamic update is working on the server with equality '=' condition only and not with <,<=,> or >=
Thanks
Hi Bill, I do not have this line in my license. I guess it could be an issue but I'm still able to do dynamic updates on server when I use just the = condition
This line works on server:
UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date = '$(vUserDate)';
This doesn't work:
UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date > '$(vUserDate)';
I'm guessing that if I was restricted by license then the first line may not have worked either.
Thanks,
Varun
Hi,
there is nothing special in the license that you should have, only the user security permissions must be applied, i have already faced the same issue where it worked on the server but not from the access point, and i did open a CRM ticket with qliktech and they have only requested to add the user that is using the dynamic update to the qlikview administrator group.