Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Marcio_Campestrini
Valued Contributor

Call a stored procedure from qvw

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?

Márcio Rodrigo Campestrini
1 Solution

Accepted Solutions
Employee
Employee

Re: Call a stored procedure from qvw

4 Replies
Not applicable

Re: Call a stored procedure from qvw

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.

Employee
Employee

Re: Call a stored procedure from qvw

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
Valued Contributor

Re: Call a stored procedure from qvw

Hi Clever,

Can you point me to one of this extensions?

Márcio Rodrigo Campestrini
Employee
Employee

Re: Call a stored procedure from qvw