Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks for this... makes sense