When dbForge Fusion executes any statement returning a result set, the retrieved data is displayed in Data Editor of the Data view of the same SQL document or the Data window. This topic tells how to edit the data in grid.
Tip: To discard changes, click the Cancel Edit button or select the Cancel Edit option from the shortcut menu.
In dbForge Fusion, you can also edit data right after retrieving it from a table or in the data view after any query was executed.
To retrieve data, select Retrieve Data from the shortcut menu of the table in Database Explorer. After this a window asking if you want to make the received data grid editable or not will appear. If you want to make the grid editable, click the Make Editable button, if you want the grid to be read-only, click Keep Read-Only. You can check the Don’t show this message again check box, and the message won’t appear when you click Retrieve Data any more.
To make data received after clicking Retrieve Data editable you can also choose the table name from the Table drop-down list on the toolbar, or leave it read-only by selecting (read-only).
If you choose the read-only mode, you will gain in the performance aspect, as the application will work faster in this mode.
To edit data in join query results, you should set the table you want to edit data from to the editable mode, as described above. After you set one table as editable, the data of other tables included into the result will become light-gray.
When you change the mode of any table from read-only to editable or vice versa, a balloon with the corresponding message is shown on the status bar.
Use the shortcut menu or the corresponding buttons under the grid. For example, you can do the following:
Tip: Use Set Value To menu to quickly set an empty string, zero, or a current date.
You can easily select and copy the data just like cells in a spreadsheet. Do either of these actions:
Tip: Using the CTRL key, you may include and exclude cells to selection. Any number of rows may be copied and pasted to some other application, for example, a spreadsheet, but when you paste data in data grid, only the first row will be pasted.
dbForge Fusion allows you to control data editing with transactions. When working with grid-based editor, you can access the following buttons on the Connection toolbar: Begin Transaction, Commit, and Rollback.
Some queries return read only data, for example, queries with aggregate functions (count, avg etc.), or data, retrieved from non-updatable views. Such data can’t be edited. It is also impossible to edit the result of executing of the script with several select statements.
When working with grid, you can see special indicators near to the focused cell. These indicators reflect current editing state.
An arrow means the row is focused.
A pencil means the row is being edited.
An I cursor means the row has been edited.
A red circle with a cross means incorrect value was entered into a cell. You must either fix the value or press the ESCAPE key to cancel changes made to the cell.