Databases Reference
In-Depth Information
In your application you now have a feature that helps ensure the quality of the data being entered. This type of
data check makes sure any metric that calculates time from start to end doesn't produce a negative answer due to
dates. This improves the quality of the data and the reliability of the metrics that are produced in reports.
Tabular Form Validation
Tabular forms in APEX 4.2 are able to perform validations better than in previous versions. The wizard that creates
a tabular form also adds validations for you. The wizard creates validations automatically based on the data model.
However, a wizard can only know so much about your business process, and the data model may have more flexibility
than you want in your application.
Looking at the definition of page 230, the wizard has created a number of Not Null validations for you, based on
the
NOT NULL
attributes in the underlying
TICKETS
table. However, the wizard can't know that you require a Closed On
date when a ticket is closed. You apply that validation using a column-level tabular form validation:
1.
Edit
Page 230
of the application.
2.
Using the
Create
button, select
Page control on this page
.
3.
Select
Validation
, and click
Next
.
4.
In the
Tabular Form
select list, choose
Manage Multiple Tickets
.
5.
Once the page has refreshed, select
Column
for
Validation Level
, and click
Next
.
6.
Select
8. CLOSED_ON (Closed On)
for
Identify the Column that is to be validated
, as
shown in Figure
8-16
, and then click
Next
.
Figure 8-16.
List of items available from the tabular form
Set
Validation Name
to
CLOSED_ON is Not Null if Ticket is CLOSED
and
Error Display Location
to
Inline with Field and in Notification
, as shown in Figure
8-17
.
Click
Next
.
7.