Oracle Database Tips by Donald Burleson

Adding a Page Item to a Form with APEX

If the form wizard is used to build forms, it will eventually be necessary to add another page item to the form.  In the section above, the COMPANY field was left off the form on purpose.  The following instructions will show how to add the COMPANY column as a page item and have it participate in the automatic row processing for the page.

To create the COMPANY page item, navigate to the Page Definition screen for the application page that was just created.

1.       Click on the Create Item icon .

2.       On the Item Type page, select the Text option and click Next.

3.       On the next page, choose Text Field and click Next.

4.       On the Display position and Name page:

·         Item Name: P12_COMPANY.

·         Sequence: Leave this at the default value.  This will be changed this later in the section named Controlling Form Layout.

·         Click Next.

5.       On the Item Attributes page accept the defaults and click Next.

6.       On the Source page, shown in Figure 8.6:

·         Item Source: Database Column.

Selecting Database Column permits the new page item to participate in Automatic Row processing, both Fetch and DML.

·         Database Column Name: COMPANY.

This is telling the Automatic Row processor which database column this page item is tied to.

·         Click Next.

7.       On the Caching page, make sure the From source each time item is displayedoption is selected and click the Create Item button.

The caching is set differently for page items participating in Automatic Row Processing because when the data is selected, the session state will be replaced with the new value.  If this is not desired, set the option to Only when the value is null.

The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty

http://www.rampant-books.com/book_2005_2_html_db.htm