||Oracle Database Tips by Donald Burleson
Examining the Results of the Tabular Form Wizard
The Form Wizard creates a report region, some
buttons, some processes, and a branch.
In the regions section, a Report region has been created. Tabular
Forms are really reports with editable fields.
buttons were created by the wizard. The cancel button is a simple
redirect, which means it will not execute page processes. The other
three buttons, Multi-Row Delete, Submit, and Add, are used in the
conditional processing of the automatic row processes. More about the
buttons will be included later in the Examining Tabular Form Buttons
Automatic Row processes were explained in the section on Forms.
Tabular forms have something similar called Multi Row processes.
There are three processes that work on Tabular Forms: Multi Row
Update, Multi Row Delete, and the Add Rows to Tabular Form process.
These processes dynamically build the SQL statements for updating the
data in the database table.
Examining Tabular Form
There is something special about the Tabular Form
MULTI_ROW_DELETE button. The others simply submit the page and the
processes use the REQUEST in the conditional processing. However, the
MULTI_ROW_DELETE button has the Optional URL Redirect set to confirm
with the user they really want to perform the delete action. The URL
Target attribute is set to the following.
The confirmDelete function asks the user if they
really want to delete data. If they answer yes, the page is submitted
and the REQUEST is set to MULTI_ROW_DELETE. The ApplyMRD process on
the page has the conditional processing set to respond to this
Examining the Multi Row
There are two Multi Row processes: Multi Row
Update (MRU) and Multi Row Delete (MRD). Their names explain the
function they perform. These processes write dynamic SQL statements
to update the database from the Tabular Form. When these processes
are used, they are set to execute On Submit - After Computations and
The MRU and MRD processes have the same
attributes. The most important section is the Source section shown in
Figure 8.14. The attributes are explained here:
The schema name for the owner of the table.
Enter the table name or view. MRD's and MRU's can only dynamically
build SQL statements for a single table or view.
This is the first column of the primary key for the table. It is used
for building the WHERE clause for the dynamic statement.
This is the column name for the second database column making up the
primary key for the table. The MRU and MRD processes can only be used
for tables that have two or fewer columns making up the primary key.
There are two Multi Row Update processes. This
is because one of them executes when the Add Rows button is pressed
and the other executes when the Submit button is pressed.
The above book excerpt is from:
Oracle Application Express
Dynamic Web Pages with OAE
Michael Cunningham & Kent Crotty