I've added example# 105 to illustrate how to efficiently validate the uniqueness of a non-primary key attribute. The example prevents two rows in the DEPT table from having the same department name (case-insensitively).
The technique implemented is described in section 9.6.2 Implementing an Efficient Existence Check of the ADF Developer's Guide for Forms/4GL Developers.
P.S. In JDeveloper/ADF 11g under development, along with many, many other enhancements, we've made it possible to enforce this type of "alternate key" unique validation in a declarative way in the future.
4:30:40 PM
|