3 Replies Latest reply: Jun 9, 2011 5:15 AM by 772524 RSS

    Using IFNULL returns failure on a custom field

    logiman
      Hello. I want to create a field with a value of zero if a shipment appointment date is null and a value of 1 if the appointment date is not null. This is in Fusion Transportation Intelligence (OBI integrated into Oracle Transportation Management). I had thought that the this would do the job:

      CASE IFNULL("- Stop Pickup Details"."Appointment Delivery",0) WHEN 0 THEN 0 ELSE 1

      The error returned is:

      +[nQSError: 10058] A general error has occurred. [nQSError: 27002] Near <,>: Syntax error [nQSError: 26012] . (HY000)+

      Any suggestions would be most welcome. Thanks very much.