Editing Data

Last modified: September 5, 2023

When dbForge Studio executes any statement returning a result set, the retrieved data is displayed in Data Editor of the Data view of the same SQL document. This topic describes how to edit the data in grid.

Editing Data

To edit data, take the following steps:

1. In the Data > Data Editor view of the SQL document, click a cell you want to edit.
2. After editing, confirm the changes by clicking End Edit under the grid or selecting the End Edit option on the shortcut menu.

Tip

To discard changes, click Cancel Edit or select Cancel Edit on the shortcut menu.

In dbForge Studio, 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, do the following:

1. In Database Explorer, select Retrieve Data on the shortcut menu of the table.
2. The pop-up window asking if you want to make the received data grid editable or not appears:
   • Click Make Editable to update data.
   • Click Keep Read-Only to restrict formatting and editing.

Note

You can select the Don’t show this message again check box to prevent showing this message when click Retrieve Data next time.

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).

Keep in mind that choosing the read-only mode will make your application 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.

Note

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.

Inserting, Deleting, and Copying Data

Use the shortcut menu or the corresponding buttons under the grid. For example, you can do the following:

• To insert NULL (instead of empty string), select Set Value To on the shortcut menu, and then click NULL, or press CTRL+0.

Tip

Use the Set Value To menu to quickly set an empty string, zero, or the current date.

• To add a new record, select the Append option on the shortcut menu or click Append under the grid.
• To delete a record from the grid, select Delete on the shortcut menu or click Delete under the grid or press the CTRL+DELETE keys.
• To copy and paste cell values, use the corresponding options on the shortcut menu.

Selecting Data

You can easily select and copy the data just like cells in a spreadsheet.

To select data, do either of these steps:

• Move the mouse pointer across the grid holding the left mouse button
• Click the first cell of the data range, press SHIFT, and, holding the SHIFT key, click the last cell. A rectangular range of cells will be selected.

Tip

With 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. However, when you paste data in data grid, only the first row will be pasted.

dbForge Studio allows you to control data editing with transactions. When working with grid-based editor, you can access the following options on the Standard toolbar: Commit and Rollback.

Note

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.

Row and Cell Indicators

When working with grid, you can see special indicators near to the focused cell. These indicators reflect the current editing state.

The row is focused.

The row is being edited.

The row has been edited.