topic Write Back to Database in QlikView https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226566#M78745 <HTML><HEAD></HEAD><BODY><P>Hi Ramnuas,</P><P>It should be possible since in the Edit Script there is an option in Settings as <STRONG>Open Database in Read and Write Mode.</STRONG> So there should be some way to write back to the database either by macro or other way.</P><P>Ay experts who has idea on this ...........Please help.</P><P></P></BODY></HTML> Mon, 04 Oct 2010 12:34:51 GMT 2010-10-04T12:34:51Z Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226563#M78742 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to use the input field to get the data from user and process the calculation. And more importantly i want to store the input for the future references.Does the same has to be done using Macros or is there anyother option for the same.</P><P></P><P>Regards,XXX</P><P></P><P></P></BODY></HTML> Mon, 04 Oct 2010 07:31:48 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226563#M78742 2010-10-04T07:31:48Z Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226564#M78743 <HTML><HEAD></HEAD><BODY><P>Hi Experts ,</P><P>Need ur suggestions on the writing the data back to database.</P><P></P><P>Regards,XXX</P></BODY></HTML> Mon, 04 Oct 2010 09:00:40 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226564#M78743 2010-10-04T09:00:40Z Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226565#M78744 <HTML><HEAD></HEAD><BODY><P>QlikView is not designed for writting back data to the database. To implement this, you have to manually create procedures to accomplish this or use budgeting tools (like Prophix) for write back.</P><P>Ramunas</P><P></P></BODY></HTML> Mon, 04 Oct 2010 10:34:16 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226565#M78744 2010-10-04T10:34:16Z Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226566#M78745 <HTML><HEAD></HEAD><BODY><P>Hi Ramnuas,</P><P>It should be possible since in the Edit Script there is an option in Settings as <STRONG>Open Database in Read and Write Mode.</STRONG> So there should be some way to write back to the database either by macro or other way.</P><P>Ay experts who has idea on this ...........Please help.</P><P></P></BODY></HTML> Mon, 04 Oct 2010 12:34:51 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226566#M78745 2010-10-04T12:34:51Z Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226567#M78746 <HTML><HEAD></HEAD><BODY><P>You can run a Stored Procedure (attached) where you could send variables to write to the database, but usually we've just exported a flat file from QlikView to a folder and had the database run a job to save it to the database.</P><P>Regards.</P></BODY></HTML> Tue, 05 Oct 2010 00:06:18 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226567#M78746 pover 2010-10-05T00:06:18Z Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226568#M78747 <HTML><HEAD></HEAD><BODY><P>I am also very interested in this topic. My question is. Is there any chance that the described procedures would also work via the Ajax Browser Client?</P><P>Thanks in advance,</P><P>Gunnar</P><P></P></BODY></HTML> Fri, 14 Jan 2011 11:48:13 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226568#M78747 2011-01-14T11:48:13Z Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226569#M78748 <HTML><HEAD></HEAD><BODY><P>Your best choice with the AJAX client is to create an extension object.</P></BODY></HTML> Thu, 08 Mar 2012 20:58:02 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226569#M78748 garystrader 2012-03-08T20:58:02Z Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226570#M78749 <HTML><HEAD></HEAD><BODY><P>Thanks Gary!</P><P>Are there perhaps any examples to illustrate this?</P></BODY></HTML> Thu, 08 Mar 2012 21:06:00 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226570#M78749 2012-03-08T21:06:00Z Re: Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226571#M78750 <HTML><HEAD></HEAD><BODY><P><A class="jive-link-external-small" href="http://www.citagus.com/citagus/blog/qlikview-writing-back-to-database/">http://www.citagus.com/citagus/blog/qlikview-writing-back-to-database/</A></P></BODY></HTML> Thu, 08 Nov 2012 10:03:02 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226571#M78750 Siva_Sankar 2012-11-08T10:03:02Z Re: Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226572#M78751 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>the most elegant solution:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-5970">SQL Writeback from QlikView extension object.</A></P><P></P><P>Hope it helps</P></BODY></HTML> Mon, 10 Nov 2014 11:08:36 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226572#M78751 agomes1971 2014-11-10T11:08:36Z Re: Write Back to Database https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226573#M78752 <HTML><HEAD></HEAD><BODY><P>Follow the link on Andry.</P><P>Go through it.</P></BODY></HTML> Mon, 10 Nov 2014 11:15:17 GMT https://community.qlik.com/t5/QlikView/Write-Back-to-Database/m-p/226573#M78752 sujeetsingh 2014-11-10T11:15:17Z