Like the Basic Reporting example this page shows the result of going through the create page wizard and choosing Report for page type, then Interactive Grid, and selecting EBA_DEMO_IG_EMP for the table except this time change Editing Enabled to Yes. For Primary Key choose EMPNO and remove the FLEX* columns (those will be used later). After that the columns were customized to give them nice heading labels and to select appropriate types for editing. Notice that row selector and actions menu columns are added automatically. Also the primary key column is type hidden by default. An Interactive Grid - Automatic Row Processing (DML) process is added by default when an Interactive Grid is made editable.

Here are some things to know about editing:

• Normally the grid is in navigation mode where arrow keys move from cell to cell. To enter edit mode press the Edit button or double click or press Enter key or F2 key in a cell.
• To exit edit mode press the Edit button or press Escape key in a cell.
• In edit mode the [Shift] Tab key moves to the previous or next cells. The [Shift] Enter key moves to the same column in the previous or next row.
• Edit controls such as radio groups or text areas that don't fit in a cell are displayed in a floating popup. The popup can be moved or collapsed to see the data under it. The Ctrl+F6 key will collapse or expand the floating popup.
• Use the Delete key to delete the selected rows. Use the Insert key to add a row.
• The second column is an actions menu that allows you to perform actions on the row such as Delete or Duplicate. The menu in the header is a selection actions menu that acts on the current selection.
• The Copy Down, Fill, and Clear actions work with row or cell range selection. Use Actions > Selection > Cell / Row Selection to toggle seleciton mode or press F8 key. Copy Down requires at least 2 rows selected.
• Editing is also supported in Single Row View.
• All edits are stored locally until you press the Save button. If you try to leave the page while there are unsaved changes you will be warned.
• Any action that causes refreshing the data such as changing a filter or sorting will warn if there are unsaved changes. Pagination does not affect changes.