QlikView Macro write back to database

[rakesh_kumar]

Hi Guys,

In the attached application I am trying to writeback the selected values in the listbox to the database. When I click on the 'Writeback' button its opening macro code editor. So something is not working.

I am new to the QV macros. Please could someone help me in fixing the issue?

Thanks,

RK

[rakesh_kumar]

So many VB Macro experts in the Qlik community and no one answered yet!!

Please can some one help me with this? ( rwunderlich , gwassenaar, jagan, marcus_sommer , tresesco)

Your help very much appreciated!

Thanks,

RK

[marcus_sommer]

There are various possibilities to what could be wrong. For example, the connection itself respectively the way how they is declared could have an issue, the access-rights to the db, some settings could be missing or wrong and also some other issue within the routine.

Take a look here: How to make Qlikview a real time system Update DB and Qlikview Online and here: Re: write back from front end. to the answers from Petter (there might be other ways more suitable especially with considerations to efforts and risks).

Further I would check the macro from the modul itself - there might be any error-messages within the very first line above the window (beside the button check) and I would use some own debugging steps by using msgbox which return variable-values, err.numbers and show which parts of the script runs and where did the execution stop.

- Marcus

[jagan]

Hi Rakesh,

Check this link

Dynamic Update - Using Actions

Regards,

jagan.

[agomes1971]

Hi,

please see this:

SQL Writeback from QlikView extension object.

HTH

André Gomes

[rakesh_kumar]

Hi jagan,

Thanks for sharing the link about Dynamic Update functionality. Thats really Brilliant!!

I have come across Business users often asking me about the possibility of:

1. Adding or amending the data in a QlikView Table by an End User like adding adding comments and

2. Writing that data back to a database.

The link you shared really solves the first problem. Now I am looking for help with the VB Macro that can writeback the QlikView table data back to a database table. (Please find the attached QVW file in my original question above and it contains the macro that needs to be corrected)

Many people in the Qlik Community are looking for a solution to this problem, so any help will be greatly appreciated!!

Kind Regards,

RK

[jagan]

Hi,

Check this link, hope it helps you to write data to database using Insert Statment.

Inserting records into Database using Qlikview Script

Regards,

Jagan.