5 Replies Latest reply: Sep 16, 2013 2:48 PM by mayilvahanan ramasamy RSS

    Scripting issue - QV not reading script correctly!?!

      LOAD SalesType_Code,
          Sales_Description,
          SalesType,
          GL_Acct;
      SQL SELECT *
      FROM "FPA_Admin".dbo.SALESTYPE_CODES
      WHERE SalesType_Code = "501" or SalesType_Code = "503" or SalesType_Code = "505";

       

      LOAD Svc_Plan As "PMA_ServicePlan",
          Common_Service_Plan,
          Service_Plan,
          Summary AS "Summary_ServicePlan";
      SQL SELECT *
      FROM "FPA_Admin".dbo.SERVICE_PLAN_CODES;

       

      error message:

      Field not found - <SalesType_Code>

      SQL SELECT *

      FROM "FPA_Admin".dbo.SERVICE_PLAN_CODES

       

      Issue:  The error appears to suggest that script is not being read by QV correctly,

      due to the field not matching the table in the SQL SELECT table.

       

      any suggestions????