Database Reference
In-Depth Information
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 ver-
sions. 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 flexib-
ility 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