Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

geogou1973
New Contributor II

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
Valued Contributor II

Re: Insert from Input fields to an oracle table

Community Browser