topic Re: SQL coding error ignored in refresh in QlikView

SQL coding error ignored in refresh

Fri, 12 Oct 2012 18:33:34 GMT

Hi Community

I have a SQL select from an OLEDB connection Oracle with a deliberate error. The syntax checker does not find this but more worrying is the fact that the script executes and just ignores the code entirely. The log of the reload also shows up nothing. I am using QV 11 SP1 ... anyone got any suggestions?

Test:

SELECT

p.PROJECT_ID AS ProjectId, p.PROJECT_NAME AS ProjectName, p.DISPLAY_STATUS AS Phase,

CASE

WHEN k.request_type_id IN (30281, 30462,30431)

THEN 'Simple Projects'

ELSE 'GCM Projects'

END AS Methodology

FROM

KCRT_FG_PFM_PROJECT k,

PM_PROJECTS p,

KCRT_REQ_HEADER_DETAILS kc

WHERE

k.PRJ_PROJECT_ID = p.PROJECT_ID

AND p.STATUS = 0

AND p.DISPLAY_STATUS NOT IN ('On Hold')

AND kcbadbadbad.REQUEST_ID = p.PFM_REQUEST_ID ; // <-- spot the deliberate error

regards

Ian

Re: SQL coding error ignored in refresh

Gysbert_Wassenaar — Fri, 12 Oct 2012 18:53:08 GMT

The select statement is not something qlikview parses, but just something that it hands to the dbms (in your case Oracle) to execute. Qlikview itself doesn't understand any of the multitude of sql dialects. Therefore it can't catch any errors. So, always try out your sql statements on the database yourself first.

Re: SQL coding error ignored in refresh

Mon, 15 Oct 2012 08:55:08 GMT

Thanks for this... makes sense