====== 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

<note tip>You can also modify the presentation of the [[valentina:products:vstudio:help:data_editor:layouts | Data Editor with custom layouts]]. **This feature is only available in Valentina Studio Pro**.</note>


===== How to open Data Editor =====

You can open Data Editor in a few ways from within the [[valentina:products:vstudio:help:schema_editor:schema_editor | Schema Editor]].

  * From the Schema Editor, select [[valentina:products:vstudio:help:schema_editor:tree_view | Tree View]], select a database and then, from the toolbar, click the Data Editor button
  * Within the Schema Editor, select [[valentina:products:vstudio:help:schema_editor:tree_view | Tree View]], double-click a table to open the Data Editor
  * From the Schema Editor, select [[valentina:products:vstudio:help:schema_editor:tree_view | Tree View]], right-click a table and from the Context Menu select Open Data Editor
  
<note info>You can have more than one Data Editor at the same time.</note>


===== 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:single_table_mode | Single Table Mode documentation. ]]

{{:valentina:products:vstudio:picts:vs_data_editor_single_mode.png?800|Data Editor window}}



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

[[.:related_table_mode:related_table_mode | READ MORE HERE ... ]]

{{:valentina:products:vstudio:picts:vs_data_editor_related_person_phone_fk.png?800|Related Table Editor}}



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 [[.:.:marked_records | 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.

{{:valentina:products:vstudio:picts:vs_schema_editor_object_colors_data_editor.png|}}

<note info>Colorizing Data Editor is a Valentina Studio Pro feature.</note>

===== Data Editor Preferences =====

The Data Editor has its own [[valentina:products:vstudio:help:dialogs:preferences:data_editor |  Data Editor Preferences]].

==== Data Editor Display Preferences ====

You can adjust the font of the Data Editor through the [[valentina:products:vstudio:help:dialogs:preferences:fonts | Preferences Fonts Dialog]].