Cells
Action | Shortcut | Description |
---|---|---|
Edit | F2 | Edit a value in the selected cell or cells. Alternatively, you can double-click the cell and start typing a value. The Edit command is unavailable for read-only values.
|
Open in Value Editor | Shift+Enter | Open in a separate value editor where you can edit data that is stored in the cell. For more information about the editor, refer to Value editor. |
Show Aggregate View | Open the aggregate view where you can select values of multiple cells and get a single summary value. For more information about the view, refer to Aggregate view. | |
Revert Selected | Ctrl+Alt+Z | Revert changes that you made to a cell value. You can select a scope of different cells and revert values in this scope. For more information about reverting changes, see Submit changes to a database. |
Set Highlighting Language | Select a language that the IDE should use to highlight data in a cell. | |
Change Display Type | Select how the IDE should display binary data in the column. 16-byte data is displayed as UUID by default. | |
Set DEFAULT | Ctrl+Alt+D | Set the current cell value to the default value or the value that you specified for the column. For more information about how to view or set a default value, see Manage default and NULL values for a cell. |
Set NULL | Ctrl+Alt+N | Set the current cell value to NULL. For more information about how to allow a NULL value, see Manage default and NULL values for a cell. |
Load File... | Load a file into the field. | |
Save LOB… | For the cells that contain a binary large object (LOB). Save content of a cell into a file. | |
Copy | Ctrl+C | Copy selection to the clipboard. |
Copy Aggregation Result (SUM) | Copy a summary value for a range of cells. By default, DataSpell copies the | |
Paste | Ctrl+V | Paste the contents of clipboard into the table. |
Add Row | Add a row to the end of a table. | |
Delete Row | Alt+Delete | Delete selected rows. |
Clone Row | Create a duplicate of the selected row and adds the duplicate to the end of a table. | |
Quick Documentation | Ctrl+Q | Show information about selected objects. For different database objects, Quick Documentation shows corresponding information. For example, for a group of cells, you will see a summary for the selection. You can preview it in a regular or in a transposed view and also see the related records by their foreign keys. |
Go To | Navigation Bar | Jump to a navigation bar. | |
Go To | Database | Open the selected object in the Database tool window. | |
Go To | Related Symbol | Navigate to one of the related objects. | |
Go To | DDL | Open an object definition (DDL). | |
Go To | Row... | Ctrl+G | Jump to a specified row. In the Go to Row dialog, specify the column and row number (use the |
Go To | All Related Rows | F4 | Jump to a related record. The command options are a combination of those for Navigate between related data. and . Read more about related data inThe command is not available if there are no related records. |
Go To | Referenced Rows | Ctrl+B | Switch to a record that the current record references. If more than one record is referenced, select the target record in the popup that appears. Read more about related data in Navigate between related data. The command is not available if there are no referenced records. |
Go To | Referencing Rows | Alt+F7 | Use this command or shortcut to see the records that reference the current record. Read more about related data in Navigate between related data. In the popup that appears there are two categories for the target records:
The command is not available if there are no records that reference the current one. |
Filter by | Select a filter that you want to a column. | |
Full-Text Search… | Ctrl+Alt+Shift+F | Open a search window where you can search for data in your database or a group of databases. |
Export Table to Clipboard | Copy the whole table to the clipboard. This action does not depend on Limit page size to setting. | |
Switch Session (your_current_session_name) | Open a window to select another session or create a new one. For more information about sessions, see Managing connection sessions. |
Using the quick documentation view
The quick documentation view provides details about values in the selected cell or cells. For example, if a cell contains long text, you will see the whole text. If a cell contains an image, you will see a preview of the image. Also, you can see records that are referenced in the current record as well as the records that reference the current one.
Object | Documentation view |
---|---|
Long text | If a cell contains long text, you will see the whole text. |
Image | If a cell contains an image, you will see a preview of the image. Also, you can |
Records | The quick documentation view for records displays records that are referenced in the current record and records that reference the current one. You can switch to a transposed view. In the transposed view, rows and columns are interchanged. To switch to the transposed view, click Transposed View. For more information about the transposed view in tables, see Transpose a table. |
Productivity tips
Manage default and NULL values for a cell
When a new row is created and no values are specified for some of the cells, those cells are filled with their respective default Ctrl+Alt+D or NULL (Ctrl+Alt+N) values.
When you set default values for a cell, you can use corresponding actions from the context menu (Set DEFAULT and Set NULL).
In the Database tool window ( ), expand a data source tree.
Right-click the table and select Modify Table Ctrl+F6.
On the Columns tab, double-click the column that you want to edit.
In the Default field, specify the default value of the cell in the column. To allow NULL values, clear the Not null checkbox.
Edit multiple cell values simultaneously
Select a range of cells that you want to edit.
Start typing a new value. The changes are applied to all the selected cells.
To confirm the value, press Enter. To cancel editing, press Escape.
Saving a LOB into a file
You can save a binary large object (BLOB or LOB) from a cell into a file.
Right-click the cell that contains the LOB and select Save LOB.
In the save dialog, specify the name and location of the file and click OK.
Copy and paste cells between tables
You can copy Ctrl+C and paste Ctrl+V selected cells and ranges of cells - within the same table or from one table to another one. When pasting, DataSpell converts data types automatically if and as necessary.