2 Replies Latest reply: Oct 15, 2012 4:55 AM by Ian Maclaren RSS

    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