Databases Reference
In-Depth Information
You begin by adjusting the Manage Tickets form layout by altering the item P210_CREATED_ON so it's
automatically populated with today's date. Then you set it so it always displays in read-only mode, preventing users
from making any changes:
1.
Edit
Page 210
of the application.
2.
Edit the item
P210_CREATED_ON
by double-clicking its name.
3.
In the
Default Value
section in Figure
6-55
, enter
SYSDATE
as the
Default Value
and set
Default Value Type
to
PL/SQL Expression
.
Figure 6-55.
Specifying a default value for a date
4.
In the
Read Only
section in Figure
6-56
, set
Read Only Condition Type
to
Always
.
Figure 6-56.
Setting the read-only condition
5.
Scroll to the top of the page, and click
Apply Changes
.
You're also going to alter P210_CLOSED_ON. In order to reduce errors, you can use a little-known HTML
attribute to make the actual input field read-only. The user is then forced to use the date picker pop-up:
6.
Edit the item
P210_CLOSED_ON
by double-clicking its name.
In the
Element
region, enter
12
for
Form Element Width
.
7.
8.
Add the following text immediately after the existing text in the
HTML Form Element
Attributes
field (as shown in Figure
6-57
) :
readonly="readonly"