The Data Editor serves for editing or viewing data in the tables. Also, the Data Editor of Valentina Studio provides a powerful ability to edit data in related tables.

Here are the key features of the Data Editor:

• Browsing Records of a Table - you can browse records of a table in the spread-sheet style.

• Inline Editing - you can enter into the edit mode for a cell (field) by mouse double click.

• Picture Extended Editor - by double clicking on a cell you can open an Extended Editor for this cell. If this is a Picture field you will get Picture Extended Editor, where you can resize pictures as you want, save/load pictures from a file, and see info about the picture.

• Text Extended Editor - by double clicking on a cell you can open an Extended Editor for this cell. If this is a TEXT field you will get Text Extended Editor, where you can see and edit multi-line text.

• RecID/OID Fields View - you can hide/show these fields of a Valentina Table.

• Table Methods View - you can hide/show Table Methods (aka calculation fields). IF they are shown you see them in a light grey color, which means you cannot modify them.

• Filter of Records - powerful feature that allows filtering records of a Table easily without SQL query. You add a green filter line, then type into its cell one or a few conditions to be applied as a filter. Rules and syntax the same as in SQL query, e.g. f1 > 25, f2 LIKE 'P.T'.

• Sorting Records - you can easily sort records of the Table by a single column by clicking on its header. The next click will change the direction of sorting from Ascending to Descending, and the next click removes sorting by this column at all. The first 2 states are indicated by a small triangle icon in the column header.

• GoTo Parent Record - allows you to navigate to a parent record using the value of a Foreign Key or ObjectPtr field.

• Layouts - allows you to tune how the table content is displayed.

• Multiple Update - allows you to update multiple rows at once.

• Export - allows you to save data shown in the Data Editor in various formats (Excel, CSV, SQL, XML, JSON) or copy to clipboard.