5 Replies Latest reply on Nov 15, 2017 11:58 AM by Andi77

    Validating duplicate value in interactive gird

    Ravi10

      HI All,

       

      I am using oracle apex 5.1. i have created interactive gird and created a manual process to save. its working as expected. I need to validate a column empno where user should not able to enter duplicate value

       

       

      in the above screenshot 'EMPNO' we have 101, 102, 103. If user try to enter 101 again and press save button it should validate and show error message.

      The above is just an example i can use trigger to get unique number but we are not doing it because of some business rules. 

       

      Can any one suggest me how to validate and restrict duplicate value.

       

      Thanks in advance

      Ravi