Creating a Form Using a Wizard

Previous

Next

---

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 Database Home Page, click the Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Form.

5. Under Forms, select a type of form page as described in Table: Forms Page Types.

   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 SQL Query	Creates a form based on the columns returned by a SQL query such as an EQUIJOIN.
   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.
   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"
   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: "Building a Master Detail Form"
   Summary Page	Creates a read-only version of a form. Typically used to provide a confirmation page at the end of a wizard.
   Tabular Form	Creates a form in which users can update multiple rows in a database. See Also: "Creating a Tabular Form"

   
   

6. Follow the on-screen instructions.