Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Update Macro not working in AccessPoint

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

6 Replies
agomes1971
Specialist II
Specialist II

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

Anonymous
Not applicable
Author

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)

agomes1971
Specialist II
Specialist II

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

Anonymous
Not applicable
Author

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

Not applicable
Author

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

Anonymous
Not applicable
Author

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