8.8.7.2 Making an Existing Interactive Grid Editable

Make an existing interactive grid editable by configuring attributes in the Edit group.

End users can alter the report layout of an interactive grid using Column menus and sort options, rearrange columns by dragging and dropping, and change how data displays using options on the Actions menu. However, developers determine whether the underlying data is read-only or editable by users. When an interactive grid is editable, end users can edit the underlying data, add rows, delete rows, and refresh rows. By default, editable interactive grids include a Save button on the toolbar.

To make an interactive grid editable:

1. View the page in Page Designer:
   Page Designer appears.
2. In the Rendering tab, select the region containing the interactive grid.
3. In the Property Editor, select the Attributes tab.
   The Property Editor displays the attributes. Attributes are organized in groups
4. In the Property Editor Attributes tab, find the Edit group and update the following attributes:
   1. Enabled - Select On.
      Selecting On automatically creates a process to process the records.
   2. Allowed Operations - Select supported data manipulation operations. Options include: Add Row, Update Row, Delete Row
   3. Allowed Row Operations Column - Select a column where the column value indicates if the row can be updated and/or deleted.
   4. Lost Update Type - Select how to protect data against lost updates.

      Lost updates occur when two or more users try to update the same data, and the last update overwrites updates made by the previous user. To prevent this, updates can check the existing column value(s) in the database with the value(s) retrieved when the record was originally queried. For an example, see Page Designer Help.

      Lost Update Type options include:

      • Row Values - A checksum value is calculated for each row, when initially querying the data. The checksum is calculated by concatenating all of the updateable columns into a string and then generating a unique value. When committing the updated record, this checksum is compared to the checksum value.

      • Row Version Column - If your database table includes a column which is incremented every time a record is updated, preferably by a database trigger, then this column can be used instead of calculating checksums. Oracle does not recommend this option if your interactive grid updates data in multiple tables.

   5. Add Row If Empty - Specify whether to add a new row if the interactive grid currently has no records returned. When enabled, the No Data Found message never displays since there will always be at least one record.  If no updates are made to the record that was added it will not be inserted when the region is saved.
5. To save your changes click Save. To save and run the page, click Save and Run Page.