Table of Contents
Data Editor - Overview
The Data Editor has a simple and intuitive interface to allow you view, create, modify, delete, search and sort data in your databases using a standard table layout, much like working in a spreadsheet.
The Data Editor many kinds of data, including BLOB, picture, date, date-time, text, numbers, booleans and more, providing a corresponding mode and editor for each supported type.
Data Editor supports the following modes:
- Single Table mode
- Related Table mode
- Key Value mode
How to open Data Editor
You can open Data Editor in a few ways from within the Schema Editor.
- From the Schema Editor, select Tree View, select a database and then, from the toolbar, click the Data Editor button
- Within the Schema Editor, select Tree View, double-click a table to open the Data Editor
- From the Schema Editor, select Tree View, right-click a table and from the Context Menu select Open Data Editor
Single Table Mode
In this mode, you can see a single table in the Data Editor. You can view or modify tables in a tab in the most common display, as a number of fields (columns), and rows.
Learn more in the Single Table Mode documentation.
Related Table Mode
In this mode, you can see two tables that are related by some link.
For most Relational Databases this is a Foreign Key link. For a Valentina Database, this can be also ObjectPtr and BinaryLinks.
This mode provides some “magic” to how you working with related records. You can do quite complex analyze of related records without any SQL. Often even experts in SQL need few minutes to write corresponded SQL query to do the same things.
Records 2, 4, 5 and 6 are marked. The Record marked first gets signed with a “1”, the second with a “2”, all following with check marks. Read more about principles and advantages of marking records in the data editor here.
Customizing Data Editor
You can customize some aspects of the appearance of the Data Editor.
Colorize Data Editor
You can customize aspects of the Data Editor by applying and saving color options.
Data Editor Preferences
The Data Editor has its own Data Editor Preferences.
Data Editor Display Preferences
You can adjust the font of the Data Editor through the Preferences Fonts Dialog.