topic Re: Call a stored procedure from qvw in QlikView

Call a stored procedure from qvw

Marcio_Campestrini — Tue, 03 Jun 2014 17:27:18 GMT

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?

Re: Call a stored procedure from qvw

Tue, 03 Jun 2014 17:49:50 GMT

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.

Re: Call a stored procedure from qvw

Clever_Anjos — Tue, 03 Jun 2014 17:52:55 GMT

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

Re: Call a stored procedure from qvw

Marcio_Campestrini — Tue, 03 Jun 2014 18:23:46 GMT

Hi Clever,

Can you point me to one of this extensions?

Re: Call a stored procedure from qvw

Clever_Anjos — Tue, 03 Jun 2014 18:28:11 GMT

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