Data Editor allows you to view and quickly edit data right in the grid.
Execute a query that returns data.
Open the table or view editor and switch to the data view.
Use the rich set of data management options on the shortcut menu.
If you want to retrieve all 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. In this case, you can choose either of the following actions - continue retrieving data, cancel retrieving data, or turn on Paginal Mode.
To simplify data analysis, you can use the following features:
By default, Paginal Mode is enabled in data view with 1000 records per page, so only 1000 records are displayed at once.
You can change columns order and width, group by order by dragging column headers to the required place. You can fit the column width to the column content by right-clicking on an appropriate header and choosing Best Fit from the shortcut menu. To adjust widths of all columns at once, choose Best Fit (all columns) instead. Note that this operation can take some time when there are many records in the grid.
To refresh data, click Refresh on the Data menu (for the Data view), the shortcut menu, or on the toolbar. To abort a too long refresh operation, click Stop Refresh on the Data menu (for Data view) or on the toolbar.
The Grid rows background and foreground colors can be set. You can set them separately for odd and even rows, focused row, selected rows, focused cell, and group rows.
Data row can be viewed, edited, and printed as cards.
Tip: you can use the down arrow to add an empty row to the table displayed in the grid. If you’ve added an empty row accidentally, you can easily delete it using the up arrow.
Null values 0000-00-00 in fields of a DATE data type are displayed as 01.01.0001. Null values of the TIMESTAMP fields are displayed as 01.01.0001 0:00:00.