Defining an Updatable Column

Previous

Next

---

You can make a column updatable by editing Tabular Form Element attributes on the Column Attributes page. Note that the Application Express engine can only perform updates if:

• A multirow update is defined

• A PL/SQL process is implemented to process updated data

• When using the built-in tabular form elements and display types, then the report has to be defined using the type SQL Query (updatable report)

To define updatable column attributes:

1. Navigate to the appropriate Report Attributes page. See "Editing Report Attributes".

2. Access the Column Attributes page by clicking the Edit icon adjacent to the appropriate column.

   The Column Attributes page appears.

3. Scroll down to Tabular Form Element.

4. Under Tabular Form Element, make the following selections:

   1. Display As - Select a type of updatable column.

      Use this option to make a column updatable. Updates can only be performed if a multirow update is defined, or PL/SQL process is implemented to process updated data.

   2. Date Picker Format Mask - Make a selection if you selected the Display As type of Date Picker.

   3. Element Width - Specify the width of the form item.

   4. Number of Rows - Specify the height of a form item (applicable to text areas).

   5. Element Attributes - Define a style or standard form element attribute.

   6. Element Option Attributes - Specify form element attributes for items in a radio group or check box.

   7. Primary Key Source Type - Identify the default type.

   8. Primary Key Source - Identify the default source.

      If the current column is part of the primary key defined in an MRU process, only the primary key source type and source appear.

      Otherwise, Default and Default Type appear. Use Default and Default Type to establish a relationship between two master records in a master detail form, or to set the default values for new rows.

   9. Reference Table Owner - Identify the owner of the referenced table. Use this attribute to build User Interface Defaults for reports.

   10. Reference Table Name - Identify the table or view that contains the current report column.

   11. Reference Column Name - Identify the column name that this report column references.

5. Click Apply Changes.