topic Dynamic Update Macro not working in AccessPoint in QlikView

Dynamic Update Macro not working in AccessPoint

Fri, 07 Nov 2014 06:56:20 GMT

Hi Every one,

I have a macro related to dynamic update which runs perfectly on desktop client (QV version 11.2 SR 8 64 bit).

But fails in AccessPoint and throws the following error : "Macro Parse failed. Functionality was lost".

when I comment following code .Macro is running fine

set str_SQL = ActiveDocument.DynamicUpdateCommand("INSERT INTO * (RCYC_ID,Realese_Cyc_Comment,Updated_Date_Time) values ('"&x&"','"&vcomment&"','"&vCurrDateTime&"')")

SET Result = ActiveDocument.DynamicUpdateCommand (str_SQL)

Thanks in advance.

Pratik

Re: Dynamic Update Macro not working in AccessPoint

agomes1971 — Fri, 07 Nov 2014 09:40:26 GMT

Hi,

please see this How to use Dynamic update action in QV 11

I think it will not work in access point...

Check this: QlikView Version 11 SDK

André Gomes

Re: Dynamic Update Macro not working in AccessPoint

Anonymous — Fri, 07 Nov 2014 12:40:20 GMT

Hi Andre,

Is there any way to dynamically update the data in QV.

For example : User is entering values through input box and he want to see those values in table box (without reload)

Re: Dynamic Update Macro not working in AccessPoint

agomes1971 — Fri, 07 Nov 2014 13:52:04 GMT

Hi,

as far as i know we've to implement something trough .net or creating an extension that will do what you want.

This version of QlikView,11 as not the same funcionalities than the version 9 or 10.

Regards

André Gomes

Re: Dynamic Update Macro not working in AccessPoint

Anonymous — Thu, 12 Mar 2015 11:30:18 GMT

Hi Pratik,

If you already created the Macro just do the setting as describe in below post :

http://community.qlik.com/message/659341#659341

Thanks

BKC

Re: Dynamic Update Macro not working in AccessPoint

Tue, 14 Apr 2015 15:12:05 GMT

Hi balkumarchandel ,

Did you find a solution for this? Im facing the same issue.

I need that users in AccessPoint be able to enter information into a table

Thanks,

Luciana

Re: Dynamic Update Macro not working in AccessPoint

Anonymous — Tue, 14 Apr 2015 15:23:04 GMT

Hi,

If your macro (dynamic update) is working in desktop version

you need to change following setting in QV server

Re: Dynamic Update Command in Macro not working in accesspoint

also user should be added in qlikview admin group .

then try again.

Let em know if still face the issue.

Thanks

BKC