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.