Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

writing back to DB

Hi All,

i have 4 input boxes in my app.

if the entered some data in 1st box.....i want to store that data in Oracle database with separate table.

i want to create a table with 4 fields for the 4 inputboxes in a single table.what ever the entered into the boxes that should store in that table.

how to achieve it.

i am using Qlikview 11.2 and Oracle 11g.

with out server i want to do it.

PFA image.

Regards,

Rathnam.

5 Replies
Not applicable

Hi

Follow these steps:

1. "Input Box" object to insert values

2. Create Macro to update the value

3. you need a filter to specify the updating criteria

Macro part:

ActiveDocument.GetVariable <variable name>.GetContent.String


ADODB object to be created with insert/update

you will find example on the net for sure.

Good luck

Adel

rathnam_qv
Creator
Creator
Author

Hi Adel,

Thanks for your reply.

i am not that good at vbscript.if you have any link for this plz send me.

Regards,

Rathnam.


rathnam_qv
Creator
Creator
Author

Hi Marcus,

Thanks for reply.

here they are using table from database.

but, my requirement is when the user enters some comments in the inputbox...first we need to create a table in database and the entered comments should store in the table.

Regards,

Rathnam.

marcus_sommer

Here an example Database write-back on Accesspoint which Adel Hamza mentioned.

- Marcus