An other nice feature of ApEx 4.0 will be the option to create tabular form validations. This will give tabular forms the only thing it missed so far, an easy way to validate the data before you try to save it.
In the previous editions you could write your own validation for a tabular form but you had to take care of the session state of the data you filled in, otherwise the date you changed would be lost if a validation was triggered.
To create a tabular form validation in ApEx 4.0 you just create a new validation and you will see that an extra option is present:
On the next screen you will see a list of colums present in your tabular form, just select the column you want to validate:
After that you just follow the standard procedure to create a validation in ApEx. After you trigger the validation you will see that ApEx automatically indicates on what line the error occureded:
On a side-note: if you press on “Row X” in the validation error message then your cursor automatically sets focus in the appropriate field.