sql server stored procedure and input contol

Tue, 09 Nov 2010 04:18:10 GMT

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

sql server stored procedure and input contol

Miguel_Angel_Baeyens — Tue, 09 Nov 2010 04:31:59 GMT

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

topic sql server stored procedure and input contol in QlikView

sql server stored procedure and input contol

sql server stored procedure and input contol