Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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

balkumarchandel
Specialist II
Specialist II

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

balkumarchandel
Specialist II
Specialist II

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

balkumarchandel
Specialist II
Specialist II

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