View and edit data in the Grid View

The Data Editor allows you to view and quickly edit data right in the grid.

Retrieve data for viewing

To retrieve data, do the following:

  • On the SQL toolbar, click Results as Grid before executing a query that returns data.
  • Execute the query to return the data.

Viewing data

Note

If you want to retrieve all the data from a table with a large number of records, a message warning you about the possibility of the Out of memory exception is shown, and you can choose either of the following actions - continue retrieving data, cancel retrieving data, or turn on the paginal mode. By default, a paginal mode is activated in data view with 1000 records per page so that only 1000 records are displayed at once. For more information, see Paginal Mode.

Manipulate the results output

To change the column order and width and group them by order, drag column headers to the required place. In addition, you can use a rich set of data management options from the shortcut menu.

Right-click the column header and select the required option:

  • Sort Ascending or Sort Descending to sort the column in an ascending or descending order, respectively.
  • Group By This Column to group data by the current column and automatically display it as collapsable groups.
  • Show/Hide Group By Box to display or hide the group data by the current column.
  • Hide this Column to hide the column from the Server Profile document.
  • Visible Columns to hide or show column data in the SQL document.
  • Best Fit to adjust the column width to the column content.
  • Best Fit (all columns) to adjust widths of all columns simultaneously. Note that this operation can take some time if there are many records in the grid.
  • Filter Editor to open the Filter Editor window to set filter criteria.

Manage columns

Data rows can be viewed, edited and printed as cards. For more information, see Viewing and editing data in the Card View mode.

Refresh data

To refresh data, use one of the following options:

  • On the Data menu, select Refresh.
  • Right-click the results grid and select Refresh.
  • On the results grid toolbar, select Refresh.
  • Press F5.

To abort an overly long refresh operation, select Stop Refresh on the Data menu or on the toolbar.

If you’ve edited the query text and applied changes, run the Execute command anew instead of refreshing the grid to get updated data.

View and edit data in Data Viewer

You can view and edit data in the built-in Data Viewer. To open it, use one of the following options:

  • Double-click the required cell.
  • Right-click the required cell and select Data Viewer.
  • Press the CTRL+W, R keyboard shortcut.
  • On the ribbon, select View > Data Viewer.

In the Data Viewer, you can save data to a file, copy/paste or cut data, view data in multiple formats, as well as make white spaces visible.

Data Viewer

The Data Viewer toolbar has the following controls:

Data Viewer toolbar

Save Data Save Data (Ctrl+S) allows saving data to a file.

Copy, Paste, Cut Copy (Ctrl+C) allows copying data to the clipboard.

The following controls allow viewing data in multiple formats:

Hexadecimal View Hexadecimal View (Ctrl+1)

Text View Text View (Ctrl+2)

XML View XML View (Ctrl+3)

HTML View HTML View (Ctrl+4)

Web View Web View (Ctrl+5)

Rich Text View Rich Text View (Ctrl+6)

PDF View PDF View (Ctrl+7)

JSON View JSON View (Ctrl+8)

Image View Image View (Ctrl+9)

Fit Image Fit Image (Ctrl+B)

Spatial View - Geometry Spatial View - Geometry (Ctrl+Alt+0)

View White Spaces View White Space makes white spaces visible.

Word Wrap Word Wrap adjusts the display of long text within cells or columns. When it is activated, the text automatically wraps onto the next line, making all the content visible within the cell’s width.

Edit data in Data Editor

When dbForge Schema Compare executes a statement returning a result set, the retrieved data is displayed in the same SQL document in Data Editor.

The Data Editor toolbar has the following controls:

Data Editor toolbar

Refresh data Refresh and Stop Refresh let you refresh and stop refreshing data in the grid, repectively.

Cached Updates Mode Cached Updates Mode allows you to apply data updates in a single batch, thus emulating a separate transaction. If this mode is activated, your data changes will be stored locally on the client side until you click Apply Changes. If there is no need for the changes to be applied, click Cancel Changes. If you close a document with Cached Updates Mode activated, all the changes made since the latest Apply Changes command will be canceled.

Paginal Mode Paginal Mode allows switching to the paginal mode.

Switching between pages Go to First Page / Go to Previous Page /Go to Next Page/ Go to Last Page allow switching between pages and specify the number of records per page.

Grid and Card View modes Switch to Grid View and Switch to Card View allow switching between the result grid views.

Show Group by Box Show Group by Box displays the data grouped by column.

Auto-search mode Auto-search mode turns on the auto-search mode.

Switching from read-only This menu allows switching from the read-only mode to editing.

The bottom panel of the grid has the following controls:

Records let you navigate down the grid one record at a time, or instantly get to the first or the last record in the grid.

Append and delete allow you to append or delete records from the grid.

Apply or cancel changes let you apply or cancel changes made during editing.

Select data

To select data, use one of the following ways:

  • Move the mouse pointer across the grid holding the left mouse button.
  • Click the first cell of the required data range, press and hold SHIFT, and then select the last cell. A rectangular range of cells will be selected.
  • Use CTRL+A to select all cells in the grid.

Using the CTRL key can help you include/exclude cells from selection. Any number of rows may be copied and pasted to another application (for example, a spreadsheet). However, when you paste data in the data grid, only the first row will be pasted.

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 cannot be edited. It is also impossible to edit the result of executing of the script with several select statements.

Copy and paste data

To copy the selected data, right-click it and do the following:

  • Select Copy on the shortcut menu or press CTRL+C to copy data.
  • Select Copy With Headers on the shortcut menu or press CTRL+SHIFT+C to copy data with headers.
  • Select Copy Data As on the shortcut menu to Copy Column Names Only or Copy Column Names and Types.

To paste data, select Paste or Paste As New Records on the shortcut menu or press CTRL+V.

Insert and delete data

You can use the shortcut menu or the corresponding controls under the grid. For example, you can do the following:

  • To insert NULL (instead of an empty string), select Set Value To > Null on the shortcut menu. Alternatively, press CTRL+0.

Note

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

  • To add a new record, select Append on the shortcut menu or click + under the grid.

  • To delete a record from the grid, select Delete on the shortcut menu or click - under the grid. You can also press CTRL+DEL.

Row and cell indicators

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

Focused row The row is focused.

Editing The row is being edited.

Row edited The row has been edited.

Invalid value An invalid value has been entered into a cell. You must either enter a valid value or press ESCAPE to cancel changes.