Databases Reference
In-Depth Information
3.
Select
Page Item
as the
Validation Level
, and click
Next
.
4.
Select
Create a Ticket: 20. P2_SUBJECT (Subject)
, and click
Next
.
5.
Set
Validation Name
to
P2_SUBJECT is NOT NULL
, as shown in Figure
6-14
, and click
Next
.
Figure 6-14.
Entering the details for a new validation
6.
Select
Not Null
for
Validation Type
, and click
Next
.
7.
Under the
Error Message
text area, click the quick link (in red) that reads
[#LABEL# must
have some value.]
and click
Next
.
8.
Accept the defaults on the final screen, and click
Create Validation
.
At this point, you see a new validation in the Page Processing region called
P2_SUBJECT is NOT NULL
. Next, you
use the second method to make the Created By field mandatory. To do this, simply set an attribute of the input item:
9.
Edit
P2_CREATED_BY
by double-clicking its name.
10.
In the
Settings
section shown in Figure
6-15
, set
Value Required
to
Ye s
, and click
Apply Changes
.
Figure 6-15.
Making a value required
When you return to the Page Edit screen, you see that no new validation has been created. That is because you
used the item-level attribute instead of creating a full validation. The main difference between the item-level and a full
validation is that with the item-level validation, you can't conditionally control when the attribute is applied and you
don't have direct control over the error message that is emitted.
Go ahead and run the application again. At this point, you're able to enter new tickets into the system but not see
them anywhere outside of SQL Workshop.