1 Reply Latest reply: Apr 4, 2014 12:27 PM by sivaraj seeman RSS

    Insert from Input fields to an oracle table

    gou geo



      I have a vbscript module that inserts values into an oracle table.


      sub oracle

      set db = CreateObject("ADODB.Connection")

      db.open "DSN=XXX;UID=XXX;PWD=XXX"

      set Orderfile = db.execute("INSERT INTO QLIKVIEW (STORE, SALES) VALUES ('$STORE', '$SALES');")

      set Orderfile = db.execute("COMMIT;")


      end sub


      i have created two input fields with variables STORE and SALES

      Can anyone knows how can i read the data that the variables have when i input then and insert them into the oracle table ?

      I attach a the file.

      Thank you in advance.