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

Insert from Input fields to an oracle table

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.

1 Reply
sivarajs
Specialist II
Specialist II