Switch to: V12V11V10V9V8V7V6V5

SQL Editor - Results Area Help

After you click the “Execute” button in the SQL Editor, and the query is executed successfully, the records of the result cursor appear on the Result Tab. The Result Tab sets a name for the result based on the text of the query.

Grid with Records

The grid is very similar to the grid of Data Editor but it is not 100% the same because it shows records of a cursor (recordset) but not records of a single table. Cursor by default is read-only. The cursor also can be a join of a few tables or be the result of even more complex relational operations. You can turn the read-only mode off to edit the records, just like in the Data Editor.

You can move the mouse cursor over the column name to see a tooltip with information about this column of cursor.

Status Bar of Result Panel

Under the grid, you can see a small status bar with info about the result, a read-only mode switch, and a couple of buttons on the right side:


Turn ON/OFF read-only mode in the result grid. [Valentina Studio Pro]

When the read-only mode is off, the status bar is completed with a set of editing buttons:

  1. Apply Changes - applies all changes made to the result
  2. Discard Changes - discards all not applied changes
  3. Content Editor - shows extended editor for the cell value
  4. Set NULL - sets the NULL value to the field if possible


Applies the auto-sizing option. The menu has available auto-sizing options

  1. Check Visible Rows - adjust the column widths to fit the text of visible rows
  2. Check All Rows - adjust the column widths to fit the text of all rows
  3. Don't Check Rows - don't adjust the column widths to text
  4. Wrap Values - turn ON/OFF the wrapping for cell values


Displays a menu to export the result.

  • To export the result of a SQL query, from the Export menu select the format. A Save dialog appears to allow you to save the result in the format
  • To copy just a column to clipboard, start with an appropriate query such as “SELECT t.f1 FROM t”. Add WHERE, ORDER BY, etc also into the query as appropriate. Export the result from the menu Export, select Clipboard…> Data.

Query Result Editing

Valentina Studio allows you to edit the result values right in the grid. [Pro]

After switching the read-only mode off editable columns change their color and the status bar is completed with buttons for editing.

Depending on the columns in the result set and the capabilities of the database engine and client, editing mode may be enabled for some fields but not available for others, they remain not editable. Usually, if the result contains the primary key field of the source table - all fields of this table become editable.

Result editing is available both for tables and views.

Edited values are marked with an italic font:

Each update operation is added to the console separately along with the errors that may appear during execution.

After the change has been applied it is shown as unmodified again.

Currently, the result editing is available for MySQL, PostgreSQL, SQLite and Valentina databases.


  • All fields are editable - result contains “actor_id” field.
SELECT first_name, last_name FROM actor
  • The fields are not editable - no primary key.