topic Re: macro is not working to write back data from qlikview to database in QlikView https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447935#M816592 <HTML><HEAD></HEAD><BODY><P>Hi Dhaval,</P><P></P><P>Kindly look into below thread. Hope this will help to solve your issue.</P><P></P><P><A href="https://community.qlik.com/thread/243984">QlikView Macro write back to database</A></P><P></P><P></P><P>Regards</P><P>Sumeet Vaidya</P></BODY></HTML> Thu, 07 Sep 2017 06:14:47 GMT sumeet-vaidya 2017-09-07T06:14:47Z macro is not working to write back data from qlikview to database https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447934#M816591 <HTML><HEAD></HEAD><BODY><P>hii I attached qvw file below in which macros is not working to writeback data from qlikview to database ? can any one solve this problem ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447934#M816591 dhavalvyas 2020-11-25T16:16:04Z Re: macro is not working to write back data from qlikview to database https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447935#M816592 <HTML><HEAD></HEAD><BODY><P>Hi Dhaval,</P><P></P><P>Kindly look into below thread. Hope this will help to solve your issue.</P><P></P><P><A href="https://community.qlik.com/thread/243984">QlikView Macro write back to database</A></P><P></P><P></P><P>Regards</P><P>Sumeet Vaidya</P></BODY></HTML> Thu, 07 Sep 2017 06:14:47 GMT https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447935#M816592 sumeet-vaidya 2017-09-07T06:14:47Z Re: macro is not working to write back data from qlikview to database https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447936#M816593 <HTML><HEAD></HEAD><BODY><P>hii sumeet i know this macro but i am confused in it it want work ? can you see macros and tell me where to enter database name,where to create database connection and where to enter table name ?</P></BODY></HTML> Thu, 07 Sep 2017 06:21:04 GMT https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447936#M816593 dhavalvyas 2017-09-07T06:21:04Z Re: macro is not working to write back data from qlikview to database https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447937#M816594 <HTML><HEAD></HEAD><BODY><P>Hi Dhaval,</P><P></P><P>You can debug the macro by clicking on Test Button to see on which line it is throwing error. few tips for quick check are as below:</P><P>1. Database connection string is correct. i.e. DB exists at the specified server</P><P>2. See if the variable val is getting the values or whether the Count of values is 0 thus loop is not executing</P><P>3. Most important your connection object name is <STRONG>oConn</STRONG> whereas while executing the SQL insert command you have used <STRONG>Connection</STRONG></P><P><STRONG><BR /></STRONG></P><P>Hope this helps</P></BODY></HTML> Thu, 07 Sep 2017 06:39:50 GMT https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447937#M816594 Anonymous 2017-09-07T06:39:50Z Re: macro is not working to write back data from qlikview to database https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447938#M816595 <HTML><HEAD></HEAD><BODY><P>Hi Dhaval,</P><P></P><P>Kindly provide the error message which you are getting while running macro. </P><P></P><P>If you are getting the below error </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Error message : Safety settings on this computer prohibit accessing a data source on another domain</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Then<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Try to adjust IE security settings for Local intranet - enable Access data sources across domains.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sumeet Vaidya<BR /></SPAN></P></BODY></HTML> Thu, 07 Sep 2017 07:12:35 GMT https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447938#M816595 sumeet-vaidya 2017-09-07T07:12:35Z Re: macro is not working to write back data from qlikview to database https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447939#M816596 <HTML><HEAD></HEAD><BODY><P>actually it is not running while click on button its source code is open ??</P></BODY></HTML> Thu, 07 Sep 2017 09:10:18 GMT https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447939#M816596 dhavalvyas 2017-09-07T09:10:18Z Re: macro is not working to write back data from qlikview to database https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447940#M816597 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the Error message on the Top status bar beside the Check button of the source code.</P><P></P><P>Regards</P><P>Sumeet Vaidya</P></BODY></HTML> Thu, 07 Sep 2017 11:16:40 GMT https://community.qlik.com/t5/QlikView/macro-is-not-working-to-write-back-data-from-qlikview-to/m-p/1447940#M816597 sumeet-vaidya 2017-09-07T11:16:40Z