13 Replies Latest reply: Nov 18, 2014 1:23 AM by Sergey Makushinsky RSS

    SQL script on record label for example 114 human error 113 machine error.

    PAUL YEO

      Hi All

       

       

      I like to record reject code, 114 = Reject by human error 113= Reject by machine problem.

       

       

      My SQL load script as below i get error msg :-

       

       

      LOAD

      if(kode_reject=114,"reject human error")

      if(kode_reject=113,"reject machine error") as DESC_REJECT;

      select * from record_reject_detail_plc;

       

       

      Paul