Insert, delete and edit grid data

SQL Edge® allows users to insert, delete and edit the grid data in “Relationship Table View” and “Relationship Tree View”. The “Query Result” view is also editable if all columns in the selection query are from one table and the primary key of the table is in the selected columns.

You can just click a grid cell and modify its value. Moving to next cell will save the data to database. You can use Tab key and Up and Down arrow keys to traverse the grid cells.

If a column holds long string or CLOB data, click the grid cell will display an “open editor” button as shown below.

Click the “open editor” button will display the “Edit Column Content” dialog box. You can browse and edit the column content in the dialog box, and click “OK” button to save it.

To delete a row, just select the row and right click to display the options menu. Select the “Delete Record” menu option to delete the highlighted record.

To insert a record, right click on the grid to display the options menu. Then select the “Insert Record” menu option to display the “Insert Record” dialog box:

Column values are pre-populated based on the column data types. Enter desired values for these columns and click “OK” button to insert the record. The newly inserted record will show up in the data grid:

Note that the master grid may be created based on a filter condition, and all the data in detail grids are related to a selected master record. The newly inserted records may not satisfy these filter conditions. You have to re-run the query to populate the master and detail grids if you want to see the records properly filtered.