topic How to insert record into sql using macro in qlikview in QlikView

How to insert record into sql using macro in qlikview

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

Hi all,

i have a qlikview document where i need to insert record into sql db from qlikview document by using macro or any other process .

please share me the way you know. and if you know using macro please share the code .

Thanks,

Narasimhak.

rwunderlich techvarun stalwar1 swuehl kenphamvn

Re: How to insert record into sql using macro in qlikview

ariel_klien — Tue, 26 Sep 2017 06:43:54 GMT

Hi,

you can use the script to insert to DB...

Connect to sql;

sql insert into DB.table (a,b,c) values (a,b,c);

Ariel

Re: How to insert record into sql using macro in qlikview

Anil_Babu_Samineni — Tue, 26 Sep 2017 07:00:22 GMT

This is working for me and tested

CUSTOM CONNECT TO "Provider=MyPackage.exe;driver=Personal;host=Anil_Connection;port=9999;db=DB_Name;FetchTSWTZasTimestamp=1;MaxVarcharSize=262144;XUserId=abc;XPassword=123;";

[Sample1]:

SELECT "col1"

FROM "public"."Sample1";

SQL INSERT INTO public."Sample1"(col1) VALUES ('1234');

Re: How to insert record into sql using macro in qlikview

Anonymous — Tue, 26 Sep 2017 07:19:23 GMT

I need the script on button click but your code will work on reload i think

Re: How to insert record into sql using macro in qlikview

Anonymous — Tue, 26 Sep 2017 07:21:29 GMT

Can i have it in macro for button click

Re: How to insert record into sql using macro in qlikview

Anil_Babu_Samineni — Tue, 26 Sep 2017 07:22:51 GMT

I never work .. May be tamilarasu‌ has some inputs

Re: How to insert record into sql using macro in qlikview

Anonymous — Tue, 26 Sep 2017 08:18:20 GMT

hi tamilarasu‌ can you explain me on how to write macro on button qlik

Re: How to insert record into sql using macro in qlikview

tamilarasu — Tue, 26 Sep 2017 10:01:08 GMT

Hello Narasimha,

I haven't tried to write back into SQL server before. marcus_sommer‌ might have some ideas.

Re: How to insert record into sql using macro in qlikview

marcus_sommer — Tue, 26 Sep 2017 10:13:09 GMT

I think it should be look like this one: Re: Writing to SQL DB from Macro

- Marcus

Re: How to insert record into sql using macro in qlikview

its_anandrjs — Tue, 26 Sep 2017 11:52:23 GMT

Dear marcus_sommer‌

Can you provide any sample for this or will it required any third party in between.

Regards,

Anand

Re: How to insert record into sql using macro in qlikview

marcus_sommer — Tue, 26 Sep 2017 12:15:52 GMT

Actually I don't use it myself and my last time was really many years ago and only by using vba against an Access database.

But I think it should work with the most other databases too, because it just does the same like the sql-process within the script by opening a connection to a database and transferrering a sql-statement. Important is only that the right database-driver is installed and that the various parameter are correct (in content and syntax).

- Marcus