topic Database table is seemingly picky... in QlikView https://community.qlik.com/t5/QlikView/Database-table-is-seemingly-picky/m-p/480394#M687398 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>what can be the reason that one app I have developed can access a certain table in a database no problem and another app - with a valid connection_string (it can access other tables in this DB) and the exact same (pasted) code cannot?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Fri, 22 Nov 2013 15:49:51 GMT datanibbler 2013-11-22T15:49:51Z Database table is seemingly picky... https://community.qlik.com/t5/QlikView/Database-table-is-seemingly-picky/m-p/480394#M687398 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>what can be the reason that one app I have developed can access a certain table in a database no problem and another app - with a valid connection_string (it can access other tables in this DB) and the exact same (pasted) code cannot?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Fri, 22 Nov 2013 15:49:51 GMT https://community.qlik.com/t5/QlikView/Database-table-is-seemingly-picky/m-p/480394#M687398 datanibbler 2013-11-22T15:49:51Z Re: Database table is seemingly picky... https://community.qlik.com/t5/QlikView/Database-table-is-seemingly-picky/m-p/480395#M687399 <HTML><HEAD></HEAD><BODY><P>HI,</P><P> which DB? are you using windows autentication?</P></BODY></HTML> Fri, 22 Nov 2013 15:53:17 GMT https://community.qlik.com/t5/QlikView/Database-table-is-seemingly-picky/m-p/480395#M687399 bbi_mba_76 2013-11-22T15:53:17Z Re: Database table is seemingly picky... https://community.qlik.com/t5/QlikView/Database-table-is-seemingly-picky/m-p/480396#M687400 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>Connect to the database via script (Connection), without pasted code from another app</P></BODY></HTML> Fri, 22 Nov 2013 15:54:16 GMT https://community.qlik.com/t5/QlikView/Database-table-is-seemingly-picky/m-p/480396#M687400 MayilVahanan 2013-11-22T15:54:16Z Re: Database table is seemingly picky... https://community.qlik.com/t5/QlikView/Database-table-is-seemingly-picky/m-p/480397#M687401 <HTML><HEAD></HEAD><BODY><P>Thanks to you two,</P><P></P><P>I solved it now - it was of course in my code - there was a WHERE EXISTS clause and the filtering_table used in that clause was, in the app I was comparing to, IN FRONT of the tab with the code - of course it worked. In the app where the code didn't work, it was BEHIND - obviously it wouldn't work... just took me awfully long to realize.</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Fri, 22 Nov 2013 16:04:18 GMT https://community.qlik.com/t5/QlikView/Database-table-is-seemingly-picky/m-p/480397#M687401 datanibbler 2013-11-22T16:04:18Z