This discussion is archived
13 Replies Latest reply: Sep 16, 2010 1:06 AM by 773212 RSS

How to do Unique Key Validation

Paul (MITsa) Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points