Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.