Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

datanibbler
Esteemed Contributor

Database table is seemingly picky...

Hi,

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?

Thanks a lot!

Best regards,

DataNibbler

3 Replies
bbi_mba_76
Valued Contributor

Re: Database table is seemingly picky...

HI,

which DB? are you using windows autentication?

Re: Database table is seemingly picky...

Hi

Try like this

Connect to the database via script (Connection), without pasted code from another app

datanibbler
Esteemed Contributor

Re: Database table is seemingly picky...

Thanks to you two,

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.

Thanks a lot!

Best regards,

DataNibbler

Community Browser