Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
geogou1973
Creator
Creator

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

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.

0 Replies