topic Re: Dynamic Update not working for updating records in QlikView

Dynamic Update not working for updating records

sagar_vij99 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to build a user form where in i am fetching data from a file and have added some blank fields in it.

Now when i am trying to update a record it is not working for me. below is the query i have used and i am also attaching the qvw file.

If anybody resolves this issue please also explain where the issue was so that i can do it accurately in future.

Appreciate assistance here.

Re: Dynamic Update not working for updating records

Brett_Bleess — Tue, 18 Feb 2020 16:39:04 GMT

Just want to be sure you have all the prerequisites enabled for things to work, so first thing is the Help link info:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/QMC/Content/QV_QMC/QMC_System_Setup_QlikViewServers_Security.htm

The piece that is not spelled out very clearly there is the user attempting to run things must be a member of the QlikView Administrators local security group on the QVServer machine, and given you are trying to update, there is a catch I caught in an Article:

Dynamic Update can not execute UPDATE command for a field that currently has a selection.

Clear the field selection before updating the data.

That was the resolution on that one, so that is the only other thing of which I can think that would be blocking things. Just an FYI, this is very old technology and only still here for legacy more or less, not sure I would recommend making use of this at this point, as it is likely to be removed at some point I would expect, so you may want to search for other options too.

Regards,
Brett

Re: Dynamic Update not working for updating records

Brett_Bleess — Wed, 19 Feb 2020 19:17:25 GMT

See duplicate post:

https://community.qlik.com/t5/New-to-QlikView/Update-Record-in-Dynamic-Update-not-Working/m-p/1668331/highlight/false#M385831

Regards,
Brett