Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

New Contributor II

Insert from Input fields to an oracle table


I have a vbscript module that inserts values into an oracle table.

sub oracle

set db = CreateObject("ADODB.Connection")


set Orderfile = db.execute("INSERT INTO QLIKVIEW (STORE, SALES) VALUES ('$STORE', '$SALES');")

set Orderfile = db.execute("COMMIT;")


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

Re: Insert from Input fields to an oracle table

Community Browser