Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi Dhaval,
Kindly look into below thread. Hope this will help to solve your issue.
QlikView Macro write back to database
Regards
Sumeet Vaidya
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 ?
Hi Dhaval,
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:
1. Database connection string is correct. i.e. DB exists at the specified server
2. See if the variable val is getting the values or whether the Count of values is 0 thus loop is not executing
3. Most important your connection object name is oConn whereas while executing the SQL insert command you have used Connection
Hope this helps
Hi Dhaval,
Kindly provide the error message which you are getting while running macro.
If you are getting the below error
Error message : Safety settings on this computer prohibit accessing a data source on another domain
Then
Try to adjust IE security settings for Local intranet - enable Access data sources across domains.
Regards
Sumeet Vaidya
actually it is not running while click on button its source code is open ??
Hi,
Check the Error message on the Top status bar beside the Check button of the source code.
Regards
Sumeet Vaidya