2 Replies Latest reply: Oct 1, 2013 10:18 AM by Антон Сухарев RSS

    How can I run a sql query??? - QlikView Server

    Alberto Pozzi

      hi

       

      how can I run a query on a db using a macro??

       

       

      on the desktop version i use this macro:

      set con = CreateObject("ADODB.Connection") 
      
          con.Open("Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\demo_sviluppo\Budget_Vendite\Bgt_Salvataggi.accdb;")
      
        ins = "INSERT into Bgt_Salvataggi values ('3','ciao')"
      
        con.execute(ins)
      
          con.Close
      
      

       

       

      I need help on the server version??

       

       

      thanks for the replies!