4 Replies Latest reply: May 22, 2013 9:28 PM by Cristina Fiacconi RSS

    Where... IN returning an error

    Cristina Fiacconi

      Hello,

       

      Can anyone help with the reason why I'm getting the error message:

      "

      SQL##f - SqlState: 37000, ErrorCode: 8258, ErrorMsg: [Jade Software Corporation][JADE ODBC Server] Expecting: 'comparison operator'; found 'IN' at 60

      SQL SELECT *

      FROM HRLeaveRequest

      WHERE myHRLeaveRequestStatus IN('02162.0000000600','02162.0000000601','02162.0000000604')

      "

       

      When I run the following script:

       

      LOAD

             calculatedDays,
           calculatedHours,
           dateFrom,
           dateTo,
           enteredLeave,
           approvalLastAction,
           myHRPerson,
           myHRTransTypePay as TransType,
           cancelReason,
           myHRLeaveRequestStatus
      ;

          

      SQL SELECT *

      FROM Table_Name

      WHERE myHRLeaveRequestStatus IN('02162.0000000600','02162.0000000601','02162.0000000604');

       

      Regards