2 Replies Latest reply: Feb 25, 2014 2:31 AM by jagan mohan rao appala RSS

    using Macro excu Store Procedure in qlikview

    sunil kumar

      While using below script is successfully inserting those i given parameters into Sql sever database ie store procedure that fine my question is that How To get values of the Database ? and if we Get where it will store and how to do that?


      sub Trigger

      Set conn = CreateObject("ADODB.Connection")

      Set rs = CreateObject("ADODB.Recordset")

      ' String connection

      strConn = "Connection Name"

      ' Open the connection

      conn.Open strConn

      parameter1= date1

      parameter2= date2

      ' Execute the stored procedure

      sqlQuery = "EXEC [dbo].[GetDatename]  '2013/11/1','2013/2/2','25' "

      rs.Open sqlQuery, conn, adOpenForwardOnly

      end sub