Insert/Delete Rows
The dataset must be editable for you to make any changes. Understand Editable Resultsets
To insert a blank row
Click on the data grid toolbar.
To copy an existing row
Right-click the cell you want to copy and select Duplicate Row. If you have a sequence set, then the sequence number advances when you finish editing.
To delete a row
Click on the data grid toolbar.
Post/Revert Edited Data
The dataset must be editable for you to make any changes. Understand Editable Resultsets
To post data
- Make changes to an editable resultset in the data grid.
- Click in the grid navigator.
To revert data
Click in the grid navigator.
Edit Data in Popup Editor
You can view and edit data in a Popup Editor. This feature is helpful when there is too much data to view in the data grid.
Note: The dataset must be editable for you to make any changes. Understand Editable Resultsets
To edit data in the Popup Editor
Right-click a cell in the data grid and select Popup Editor.
Perform Calculations on Grid Cells
You can perform basic calculations on data grid cells, such as finding the sum or average of the selected cells.
Note: This feature is not available if Row Select is enabled. To disable Row Select, right-click the grid and clear the Row Select option.
To perform calculations on grid cells
-
Select adjacent cells in the grid.
Note: Calculations on non-adjacent cells is not supported.
-
Click in the grid toolbar (CTRL+N). The calculations display in a new row below the grid.
Tip: You can also right-click the grid and select Calculate Selected Cells.
- To include additional types of calculations (such as the average or count), click the arrow by and select the appropriate options.