Call a stored procedure from qvw

[Marcio_Campestrini]

Hi everybody

I have a requirement: user wants to insert some values via stored procedure during the use of the application. I realized how to call the procedure, but I don't know how to execute the script, instead of reloading all the application. I've tried to create a second application only for call the procedure, but I'm unable to pass the values I needed form one application to another.

Somebody can help me with this?

[#2]

Perhaps in the 1st app you could create a macro that stores those values to file. The second app can read from this file during reload.

[Clever_Anjos]

The best way in my humble opinion is encapsulate your procedure inside a WebService.

There´s some extensions here into the Community that enable calling a webservice on-the-fly

[Marcio_Campestrini]

Hi Clever,

Can you point me to one of this extensions?

[Clever_Anjos · Accepted solution]

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