Uncomplicated data editor with high productivity tools for working with tables, records and fields.
The Valentina Studio Data Editor lets you work directly with data stored in tables. It also provides powerful ability to edit data in related tables.
From within the Data Editor, you can add, edit, delete, sort, filter, import and export data. You can also copy-paste directly into a table in the Data Editor. Valentina Studio has a growing number of general, visual editors as well as editors expressly created for data formats specific to individual database platforms.
Valentina Related Table Editor
When you open a Data Editor for a table that have at least one Link to other tables (self-recursive link also) the Data Editor will show two views for two tables.
For all supported relational databases, the Related Table Editor supports Foreign Key links. For Valentina Database it also works with ObjectPtr and Binary Links. ForeignKey and ObjectPtr can be of 1:1 and 1:M types. A BinaryLink can be also M:M type.
Use Data Filtering to select a subset of records of a table to specify simple search conditions. Add one or more filter rows. You can see filter row(s) in green at the top of the table grid. In filter row(s), you can define a search condition for each field that work just like a SQL query. Valentina Studio combines all these search conditions to produce a SQL query and then execute it.
You can alternatively create a WHERE filter for more complex expressions.
Use a pop up menu to execute recently used filters or add your filters to your favorites.
Custom Value Formatting
In Valentina Studio Pro, you can apply and save formatting options to values within the Data Editor, depending on their types. Some options are universal and some are available only to certain database engines.
In addition, you can also create custom input masks to ensure that data entered conforms and is displayed in a productive way.
Valentina Custom Data Editors
Valentina Studio includes several custom, visual editors for displaying and working with different data types, no matter if it an officially recognized type or stored and detected within a BLOB field content.
Valentina Studio also supports custom data editors of data types native only to specific databases.
Visual HTML Editor
If Valentina Studio detects binary or textual data containing HTML, markup then highlighting and visual editing then becomes an option.
Visual JSON Editor
If Valentina Studio detects JSON in binary or textual data then highlighting and visual editing then becomes an option. The Inline Editor lets you edit in the table grid with syntax highlighting. The Advanced Editor is presented as an ordinary modal dialog to view JSON structure and edit values within the tree. For binary fields JSON can be viewed in the hexadecimal form using the Data tab.