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

    Insert from Input fields to an oracle table

    geo gou

      Hello.

       

      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;")

      db.Close

      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.