Creating Forms

Creating a Form Using a Wizard

The easiest way to create a form is to use a wizard. For example, the Form on Table or View Wizard creates one item for each column in a table. It also includes the necessary buttons and processes required to insert, update, and delete rows from the table using a primary key. Each region has a defined name and display position; all other attributes are items, buttons, processes, and branches.

To create a form using a wizard:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Form and click Next.

5. Under Forms, select a type of form page as described in Table 7-6.

   Table 7-6 Forms Page Types

   Form Page Type	Description
   Form on a Procedure	Builds a form based on stored procedure arguments. Use this approach when you have implemented logic or data manipulation language (DML) in a stored procedure or package.
   Form on a Table or View	Creates a form that enables users to update a single row in a database table.
   Form on a Table with Report	Creates two pages. One page displays a report. Each row provides a link to the second page to enable users to update each record. Note: This wizard does not support tables having more than 127 columns. Selecting more than 127 columns generates an error.
   Master Detail Form	Creates a form that displays a master row and multiple detail rows within a single HTML form. With this form, users can query, insert, update, and delete values from two tables or views. See Also: "Creating a Master Detail Form"
   Tabular Form	Creates a form in which users can update multiple rows in a database. See Also: "Creating a Tabular Form"
   Form on a SQL Query	Creates a form based on the columns returned by a SQL query such as an EQUIJOIN.
   Summary Page	Creates a read-only version of a form. Typically used to provide a confirmation page at the end of a wizard.
   Form on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, and a submit button. See Also: "Creating a Form on a Web Service"
   Form and Report on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, a submit button, and displays the results returned in a report. See Also: "Creating an Input Form and Report on a Web Service"

   
   

6. Follow the on-screen instructions. To learn more about a specific field, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

Creating a Tabular Form

A tabular form enables users to update multiple rows in a table. The Tabular Form Wizard creates a form to perform update, insert, and delete operations on multiple rows in a database table.

To create a tabular form:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Form and click Next.

5. Select Tabular Form and click Next.

   The Tabular Form Wizard appears.

6. For Table/View Owner:

   1. Specify the table or view owner on which you want to base your tabular form.

   2. Select the operations to be performed on the table (for example, Update, Insert and Delete).

   3. Click Next.

7. For Table/View Name, select a table and click Next.

8. For Displayed Columns:

   1. Select the columns (updatable and nonupdatable) to include in the form.

      Note that you can modify the column order or your SQL query after you create the page.

   2. Click Next.

9. For Primary Key, select the Primary Key column and a secondary Primary Key column (if applicable) and click Next.

10. For Primary Key Source, select a source type for the primary key column and click Next. Valid options include:

    • Existing trigger - Select this option if a trigger is defined for the table. You can also select this option if you plan on specifying the primary key column source later after completing the form.

    • Custom PL/SQL function - Select this option if you want to provide a PL/SQL function to generate returning key value.

    • Existing sequence - Select this option if you want to pick the sequence from a list of sequences available in the selected schema.

11. On Updatable Columns, select which columns should be updatable and click Next.

12. On Page and Region Attributes:

    1. Specify page and region information.

    2. Select a region template.

    3. Select a report template.

    4. Click Next.

13. On Tab, specify a tab implementation for this page and click Next.

14. On Button Labels, enter the display text to appear for each button and click Next.

15. On Branching, specify the pages to branch to after the user clicks the Submit and Cancel buttons and click Next.

16. Click Finish.

Creating a Master Detail Form

A master detail form reflects a one-to-many relationship between two tables in a database. Typically, a master detail form displays a master row and multiple detail rows within a single HTML form. With this form, users can insert, update, and delete values from two tables or views.

To create a master detail form:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Form and click Next.

5. Select Master Detail Form and click Next.

   The Master Detail Wizard appears.

6. On Master Table:

   1. Select the table or view owner.

   2. Select a table or view name.

      The columns in that object appear under Available Columns.

   3. Select the columns to display in the form and then click the arrow keys to move them to Displayed Columns.

   4. Click Next.

7. On Detail Table:

   1. Specify whether to show only related tables by selecting Yes or No.

   2. Select the table or view owner.

   3. Select a table or view name.

      The columns in that object appear under Available Columns.

   4. Select the columns to display in the form and then click the arrow keys to move them to Displayed Columns.

   5. Click Next.

8. On Primary Key:

   1. Primary Key(s) of Master Table - Select the primary key (or keys) of the master table. You can select maximum of two primary keys for master table.

   2. Primary Key(s) of Detail Table - Select the primary key (or keys) of the detail table. You can select maximum of two primary keys for detail table.

   3. Click Next.

9. On Master Detail Link, define the relationship between the master and detail tables and click Next.

10. On Primary Key Source, select the primary key column for the master table and click Next. Then select the primary key column for the detail table and click Next. Options include:

    • Existing trigger - Select this option if a trigger is defined to populate the primary key, or if the user will be expected to enter the primary key value manually. Detail tables do not support user entered primary key values.

    • Custom PL/SQL function - Select this option if you want to provide a PL/SQL function to populate the primary key.

    • Existing sequence - Select this option if an existing sequence will be used to generate the primary key.

11. On Master Options, specify whether to include master row navigation and click Next.

    If you include master row navigation, define navigation order columns. If a navigation order column is not defined, the master update form navigates by the primary key column.

12. On Layout, specify how to build the master detail and click Next. Options include:

    • Edit detail as tabular form on same page creates a two page master detail. Edit detail on separate page creates a three page master detail.

    • Edit detail on separate page creates a three page master detail.

13. On Page Attributes, review and edit the master page and detail page information and then click Next.

14. On Tab, specify whether to include a tab set and click Next.

15. Click Create.

Creating a Form Manually

You can also create a form manually by performing the following steps:

• Create an HTML region (to serve as a container for your page items)

• Create items to display in the region

• Create processes and branches

To create a form manually by creating and HTML region:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. Create an HTML region:

   1. Under Regions, click the Create icon.

   2. Select the region type HTML.

   3. Follow the on-screen instructions.

3. Start adding items to the page:

   • Under Items, click the Create icon.

   • Follow the on-screen instructions.

BEGIN
  INSERT INTO T ( first_name, last_name )
     VALUES  (:P1_FIRST_NAME, :P1_LAST_NAME);
END; 

BEGIN
    UPDATE T
       SET first_name = :P1_FIRST_NAME,
           last_name = :P1_LAST_NAME
    WHERE ID = :P1_ID;
END; 

BEGIN
    DELETE FROM T
    WHERE ID = :P1_ID;
END;

FOR C1 in (SELECT ename, sal
FROM emp WHERE ID=:P2_ID)
LOOP     
     :P2_ENAME := C1.ename;
     :P2_SAL := C1.sal;
END LOOP;

Validating User Input in Forms

You can use validations to check data a user enters before processing. Once you create a validation and the associated error message, you can associate it with a specific item. You can choose to have validation error messages display inline (that is, on the page where the validation is performed) or on a separate error page.

Creating an inline error message involves these steps:

• Create a validation and specify error message text.

• Associate the validation with a specific item.