dhborchardt
Partner - Creator
2013-09-12
01:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cannot see Access Query if it calls a Function
I cannot connect to an access query (does not appear in 'Create Select Statement/Database tables') if a function call is made to a module within the query I am attempting to select from. I tried to use anther query on top of that one but still did not appear in the 'Create Select Statement' window. Is this a limitation or am I doing something wrong?
Access 2010
Qlikview 11, 64 bit
- Tags:
- qlikview_scripting
593 Views
1 Solution
Accepted Solutions
2013-09-12
02:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Try to rewrite the logic in qlikview script. It's pretty powerful so it might surprise you what you can do. And ask us if you need help.
- Use a 'real' database as data source
- Create a vbscript function in the module and call it as a function in the script (example here).
talk is cheap, supply exceeds demand
469 Views
4 Replies
2013-09-12
01:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As far as I know that's a limitation of the odbc/oledb driver for MS-Access. It allows access to the data, but won't run code.
talk is cheap, supply exceeds demand
469 Views
dhborchardt
Partner - Creator
2013-09-12
02:09 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks. In this case I was able to accomplish it pretty simply in the load statement. What is the workaround if there is no easy button?
469 Views
2013-09-12
02:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Try to rewrite the logic in qlikview script. It's pretty powerful so it might surprise you what you can do. And ask us if you need help.
- Use a 'real' database as data source
- Create a vbscript function in the module and call it as a function in the script (example here).
talk is cheap, supply exceeds demand
470 Views
dhborchardt
Partner - Creator
2013-09-12
02:44 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yeaaa,, I was waiting for that. Unfortunately I was not there for that decision. Thanks again.
469 Views