0 Replies Latest reply: Apr 4, 2014 8:03 AM by geo gou RSS

    How to read values from an input field and add them into an oracle table?

    geo gou

      Hello.

       

      I have a vbscript module that inserts values in 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 ('101', '42000');")

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

      db.Close

      end sub

       

      It is working correct and inserts the values into the oracle table.

      How can i insert values from an input box with variables into the oracle table ?

      Let's say i create a variable $(STORE) and $(SALES)

      How can i read the variables and insert the values into the oracle table ?

      I attach a file.