- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to insert record into sql using macro in qlikview
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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);
BR
Ariel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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');
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I need the script on button click but your code will work on reload i think
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can i have it in macro for button click
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I never work .. May be tamilarasu has some inputs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi tamilarasu can you explain me on how to write macro on button qlik
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Narasimha,
I haven't tried to write back into SQL server before. marcus_sommer might have some ideas.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think it should be look like this one: Re: Writing to SQL DB from Macro
- Marcus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear marcus_sommer
Can you provide any sample for this or will it required any third party in between.
Regards,
Anand
- « Previous Replies
-
- 1
- 2
- Next Replies »