Databases Reference
In-Depth Information
7.
In the
Settings
section, change
Value Required
to
Ye s
.
In the
Element
section, set
Form Element Width
to
80
and
Form Element Height
to
5
.
8.
9.
Click
Apply Changes
.
Next, set page 3 to be a public page. You want any user—authenticated or otherwise—to be able to send you
a message through the Contact Us page:
10.
Edit
Page 3
of the application.
11.
Set
Page 3
to be a public page. Refer back to Chapter 5 for detailed steps.
Finally, modify the process that was created to include a success message:
12.
In the
Page Processing
tree, edit the process
Run Stored Procedure
by double-clicking its name.
13.
In the
Messages
region, enter the following for the
Process Success Message
:
Your message has been sent.
14.
Scroll to the top, and click
Apply Changes
.
Run your application, and test the Contact Us form. Each time you submit a record, an e-mail is sent to
info@example.com
. If you want to change the destination address for the e-mail, you can use the SQL Workshop's
Object Browser to edit the
CONTACT_US
procedure.
Looking Behind the Scenes
From the user perspective, there is no indication that the form you've just created was created on a procedure. Looking
in the Application Builder, the objects in the Page Rendering sections are similar to what you saw in your form on a table
on page 2, but not exactly. Let's take a look to see what makes your form on a procedure different from the form on a
table. Edit page 3 of your application. The Application Builder page should look similar to that in Figure
6-23
.
Figure 6-23.
Elements of a form on a procedure as viewed from Application Builder