writing back to DB

[rathnam_qv]

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.

[#2]

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]

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.

[marcus_sommer]

See here:

Write Back to Database via ETL process (using CSV or XML)

Write back to database via XML output or web service

SQL Writeback from QlikView extension object.

- Marcus

[rathnam_qv]

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