8 Replies Latest reply on Sep 4, 2018 8:40 AM by John_K

    Validate Detail Block Item Record in Form Personalisation

    3383498

      Hello,

       

      I need to validate a detail block record using Form Personalisation:

       

      I am using OM_PRE_BOOK_EVENT

       

      ='DECLARE

      BEGIN

      FOR I in (SELECT AUTH_USER FROM TEST_LINE WHERE  header_id = ''||${item.TEST_LINE .HEADER_ID.value}||'')

      LOOP

         IF I.AUTH_USER IS NULL THEN

            MESSAGE('The user cannot be left blank');

         END IF;

      END LOOP;

      END'

       

      i am getting Error could not be evaluated.Please check the syntax