topic Re: QlikView Macro write back to database in QlikView

QlikView Macro write back to database

rakesh_kumar — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: QlikView Macro write back to database

rakesh_kumar — Wed, 21 Dec 2016 10:07:06 GMT

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,

Re: QlikView Macro write back to database

marcus_sommer — Wed, 21 Dec 2016 11:17:16 GMT

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

Re: QlikView Macro write back to database

jagan — Thu, 29 Dec 2016 15:24:09 GMT

Hi Rakesh,

Check this link

Dynamic Update - Using Actions

Regards,

jagan.

Re: QlikView Macro write back to database

agomes1971 — Thu, 29 Dec 2016 15:47:58 GMT

Hi,

please see this:

SQL Writeback from QlikView extension object.

HTH

André Gomes

Re: QlikView Macro write back to database

rakesh_kumar — Thu, 29 Dec 2016 19:05:46 GMT

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,

Re: QlikView Macro write back to database

jagan — Tue, 03 Jan 2017 02:50:32 GMT

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.