13 Replies Latest reply: Sep 16, 2010 3:06 AM by Nick Haralabidis RSS

    How to do Unique Key Validation

    Paul (MITsa)
      ADF 11, ADF BC
      I might be missing something but how do you add a validator for an unique key ?

      I have an unique key defined on the DB, this unique key has nothing to do with the primary key.
      (Its checking that a code is unique)

      In the validators on the entity object I can set an unique key validator but it only lists the
      primary key for the check definition not the unique key....

      The unique key on the DB is working as I get a nice constraint violation error, so how do I
      either add a validator for a unique key or at least trap the error in order to display a user friendly message.

      Regards
      Paul