Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Tables not visible in select statement wizard

Looking for some help as I have run out of ideas.

I have an ODBC connection to a MS SQL 64 bit database using an account which is a sysadmin on that database.

Permissions look good and if I manually script the select statement I can sucessfully read data.

My problem is when I try to use the select statement wizard none of the user created tables in user created schema's are visible. I can see all system tables fine but none of the tables in other schemas.

As I said I can manually script the statement to these tables and read data fine but I don't want to have to do this for every table.

Does anyone have any ideas on this?


1 Reply
MVP & Luminary
MVP & Luminary

It's not a solution else just a workaround which I use sometimes if I couldn't see the tables or even access the database per wizard:

select top 1 * from table;

and then creating a listbox with $Field, export the listbox to excel and doing some adjustments with expressions like adding quotes/brakets and comma's or manually like removing or renaming fields and copy & paste it back. Usually it takes just 1 or 2 minutes.

- Marcus