execute script via AccessPoint (IE or Ajax)

[wunderch]

Hi guys,

I have a script with an SQL EXECUTE Command to insert, update or delete rows in an SQL-Table via Variables.

Now I want to execute the script in AccessPoint (IE-Plugin or Ajax-Client) .

Is there any way to do this????

With Button and Action "Execute Script" it dosn't work. (only in Desktop-Client)

Thanks for your regards!

[#2]

Hi Christian,

only way to execute the script in Access Point is to create the reload task at QMC

Please check the below link suggested by JOE

http://community.qlik.com/docs/DOC-2650

HTP

[wunderch]

Hi,

I've seen this post already before, but if I trigger the programm by EDX I don't have filled the variables where the users make in the qvw on the access point.

Is there no way like Button =>Action =>Execute script?

[Peter_Cammaert]

No.

Because in the AccessPoint, there is no Desktop-like module that integrates both the display engine and the reload engine. Those tasks are handled by different services. The QlikView Server service (QVS) handles document display but cannot reload, the QlikView Distribution Service (QDS) handles document reloads but cannot show you the result. Separate systems altogether.

[Edit] Corrected spelling errors...

[Peter_Cammaert]

There are workarounds though. EDX is the main one.

[wunderch]

Hi Peter,

thanks for your reply. I understand what you describe.

What other kind of workaround do you know to update, insert or delete manual inserts from AccessPoint to SQL-Database?