sql server stored procedure and input contol

[#1]

Hi All,

I run into a problem, I have a SQL Server Stored Procedure with parameter, and I also drag a input control into QV sheet..

The SP looks like this :

TempTable:
SQL EXECUTE QVFactInternetSales $(VarTest);

The input control is bound with VarTest. But when I type a value into input control, the records can not be refreshed. Now I have to reload data

to solve this issue. How can I refresh data automatically after typing a value.

Isaac Li

[Miguel_Angel_Baeyens · Accepted solution]

Hello Isaac,

I may be missing something here, but I understand that you have an inputbox in your application for variable VarTest and you want anytime you type a value there it's passed onto the stored procedure you have in the load script. Is that right?

If yes, then you will need to reload anyway regardless of the stored procedure. For QlikView, it's just another data source. Think of doing so with a "normal" table or a view in SQL Server.

You can create a macro to reload the document every time you change that value (Settings, Document Properties, Triggers, Variable section, On Change) though:

Sub ReloadOnChange ActiveDocument.ReloadEnd Sub

Hope that helps