Databases Reference
In-Depth Information
Figure 3-12.
Tabular Form validations—created by the wizard
As you can see in Figure 3-12, the APEX Tabular Form wizard created several validations
automatically. If you remember the changes made in Listing 3-1, you will notice that this change
resulted in a validation checking the ENAME column (Validation with sequence 30 - ENAME IS NOT
NULL). The other validations are related to the data type of all existing numeric and date columns
included in the Tabular Form.
Highlighting Validation Errors
If you want to test the validations created by the wizard, you can make a couple of changes in your table
to see how they work, as shown in Figure 3-13.
Figure 3-13.
Tabular Form validations
Caution
Prior to making these changes and submitting them, you should change the sorting of your Tabular
Form from DEPTNO to EMPNO. In version 4.0.2 of APEX there is a bug described here:
http://forums.oracle.com/forums/thread.jspa?threadID=2139640
.
Change the entry for the column ENAME to NULL and modify the entry for the column SALARY to
an alphanumeric character. If you try to save that, you should receive an error like the one shown in
Figure 3-14.
