Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

SQL coding error ignored in refresh

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

Tags (1)
1 Solution

Accepted Solutions

Re: SQL coding error ignored in refresh

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.


talk is cheap, supply exceeds demand
2 Replies

Re: SQL coding error ignored in refresh

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.


talk is cheap, supply exceeds demand
Not applicable

Re: SQL coding error ignored in refresh

Thanks for this... makes sense

Community Browser