Database Reference
In-Depth Information
At this point, you should be able to navigate to your tabular form from page 200 by
clicking the Manage Multiple Tickets button.
Looking Behind the Scenes
Let's take a look at what the Tabular Form Wizard has created for you—the contents of
your tabular form. Edit page 230 to view the Application Builder page for your tabular
form. The Application Builder page will look similar to the one shown in Figure 7-11 .
Figure 7-11. The Application Builder page for the tabular form
In the Page Rendering region, APEX has created a report region. But you created a
form, didn't you? Despite its name, a tabular form is actually a SQL report with certain
column-level options enabled and some processes added to handle data manipulation.
In the Page Processing region, in the Processing section, you see two processes, Ap-
plyMRU and ApplyMRD. These special types of processes handle the multiple-row in-
serts and updates (ApplyMRU) and deletes (ApplyMRD) on the TICKETS table.
These processes handle all DML operations on the TICKETS table for you.
APEX has also created validations for several of the columns, which are created
automatically based on the TICKETS table column definitions plus any UI Defaults
defined on the TICKETS table.
In the Shared Components region are the usual page and tab templates that are the
defaults for your application.
As you can see, the ApplyMRU and ApplyMRD processes make the difference
between the report region being a static report region and a fully functional tabular
form. And it's so much easier to let the APEX wizard create all this for you!
 
 
Search WWH ::




Custom Search