topic How to writeback to the database without using webservice? Please guide. in QlikView https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005117#M341463 <HTML><HEAD></HEAD><BODY><P>How to writeback to the database without using webservice? Please guide.</P></BODY></HTML> Mon, 30 Nov 2015 06:18:30 GMT 2015-11-30T06:18:30Z How to writeback to the database without using webservice? Please guide. https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005117#M341463 <HTML><HEAD></HEAD><BODY><P>How to writeback to the database without using webservice? Please guide.</P></BODY></HTML> Mon, 30 Nov 2015 06:18:30 GMT https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005117#M341463 2015-11-30T06:18:30Z Re: How to writeback to the database without using webservice? Please guide. https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005118#M341464 <HTML><HEAD></HEAD><BODY><P>Hi snehal,</P><P></P><P>Can you please elaborate more on what are you trying to do? That would be really helpful to solve your problem.</P><P></P><P>Regards,</P><P>KC</P></BODY></HTML> Mon, 30 Nov 2015 08:26:55 GMT https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005118#M341464 2015-11-30T08:26:55Z Re: How to writeback to the database without using webservice? Please guide. https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005119#M341465 <HTML><HEAD></HEAD><BODY><P>You are talking about general Database scenario or Qlik scenario?</P></BODY></HTML> Mon, 30 Nov 2015 08:28:51 GMT https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005119#M341465 Anonymous 2015-11-30T08:28:51Z Re: How to writeback to the database without using webservice? Please guide. https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005120#M341466 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In Qlik Scenario,</P><P>Some selections are made in Qv and the same should be updated in the database on click of a button.</P></BODY></HTML> Mon, 30 Nov 2015 10:35:36 GMT https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005120#M341466 2015-11-30T10:35:36Z Re: How to writeback to the database without using webservice? Please guide. https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005121#M341467 <HTML><HEAD></HEAD><BODY><P>QV is a analytical tool, it does not allow you to <STRONG>edit/insert/update data in database</STRONG> as per my understanding<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 01 Dec 2015 04:58:08 GMT https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005121#M341467 Anonymous 2015-12-01T04:58:08Z Re: How to writeback to the database without using webservice? Please guide. https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005122#M341468 <HTML><HEAD></HEAD><BODY><P>Hope this help you <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6386" title="https://community.qlik.com/docs/DOC-6386">https://community.qlik.com/docs/DOC-6386</A></P><P></P><P>Vikas</P></BODY></HTML> Tue, 01 Dec 2015 06:19:54 GMT https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005122#M341468 vikasmahajan 2015-12-01T06:19:54Z Re: How to writeback to the database without using webservice? Please guide. https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005123#M341469 <HTML><HEAD></HEAD><BODY><P>Hi Vikas,</P><P><SPAN style="font-size: 13.3333px;">The link you have shared describes has details for the script level writeback.</SPAN></P><P></P><P>I would like to know if the writeback can be performed without the use of webservice from the accesspoint/UI.</P></BODY></HTML> Tue, 01 Dec 2015 06:54:12 GMT https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005123#M341469 2015-12-01T06:54:12Z Re: How to writeback to the database without using webservice? Please guide. https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005124#M341470 <HTML><HEAD></HEAD><BODY><P>You can write a macro that uses ADO to do the SQL work. I'm not sure (doubtful) that this would work on an Ajax client though. </P><P></P><P>-Rob</P></BODY></HTML> Tue, 01 Dec 2015 06:56:50 GMT https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005124#M341470 rwunderlich 2015-12-01T06:56:50Z Re: How to writeback to the database without using webservice? Please guide. https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005125#M341471 <HTML><HEAD></HEAD><BODY><P>try with this code in VBscript</P><P></P><P></P><P>dim sConn, oConn</P><P>Set oConn = CreateObject("ADODB.Connection")</P><P>sConn = "Provider=MSDAORA;User ID="<STRONG>yourlogin</STRONG>";Password="<STRONG>yourpassword</STRONG>";Data Source="<STRONG>your data source</STRONG>";OLEDB.NET=true;SPPrmsLOB=true;Persist Security Info=False;"</P><P>oConn.Open sConn</P><P> sSQL="<STRONG>your request</STRONG>"</P><P> oConn.Execute(sSQL)</P><P> oConn.Close</P><P> Set oConn = Nothing</P></BODY></HTML> Tue, 01 Dec 2015 09:06:41 GMT https://community.qlik.com/t5/QlikView/How-to-writeback-to-the-database-without-using-webservice-Please/m-p/1005125#M341471 vikasmahajan 2015-12-01T09:06:41Z