Databases Reference
In-Depth Information
Figure 3-14.
Tabular Form validations - error highlighting
If you remember how such validations worked before version 4, you will notice a few changes:
•
APEX is now highlighting the cells in which there are validation errors found.
•
APEX will tell you the name of the column affected by the error message.
•
APEX will provide you with a direct link for setting focus to the affected cell as a
part of the error message.
•
Most important, you didn't lose the changes you made.
In earlier versions of APEX a lot of custom coding was required to get a similar functionality. To
avoid losing the changes you made after an unsuccessful validation, it was required to display the
validation errors on an error page and press the back button.
One more important thing needs to be mentioned. If you edit one of the validations created by the
wizard, you will notice that there is a new substitution string in the Error Message. You can use
#COLUMN_HEADER# for the heading of the associated Tabular Form column in order to display the
header name as a part of the error message, as shown in Figure 3-15.
Figure 3-15.
Tabular Form validations—substitution string for column names
