topic Re: using select * giving wrong result in QlikView

using select * giving wrong result

guruprem — Wed, 30 Nov 2016 13:25:14 GMT

Hi,

One of my old query started throwing error very recently. When I investigated I found that SQL statement SELECT * FROM TABLE is not fetching all Fields from Table. Issue was corrected when I mentioned Field Names instead of *

I faced this issue on MSSQL 2008 DB. Has any one faced similar challenge? What could be best practise?

Re: using select * giving wrong result

Wed, 30 Nov 2016 13:39:09 GMT

Can you share the error msg (Image), by this we can help you to identify which error exactly it is.

Re: using select * giving wrong result

Miguel_Angel_Baeyens — Wed, 30 Nov 2016 13:44:53 GMT

Wrong result means it pulls no rows, only some rows, only some fields?

Easiest way to check is using the assistant in the script editor > Connect > then Select and see if the fields you see there are the same ones you see using MSSQL Studio.

Re: using select * giving wrong result

marcus_sommer — Wed, 30 Nov 2016 14:41:26 GMT

Maybe there are more fields or fieldnames with special chars or something similar within your database-table as the driver could handle - the use of Select * is always a bit risky.

- Marcus