Switch to: V9V8V7V6V5

Data Editor - Work with Records

Most commands with records of a table present in the in the menu Record. 

Add New Record

To add a new record into table do one of these actions:

  • choose command in the menu Record → New Record
  • press keyboard shortcut ctrl+”+”/cmd+”+”
  • click button “Add Record” at bottom

A new row will be shown in the grid and first editable cell will be activated for editing.

When you click RETURN or TAB you will be moved to the next editable cell of this row.

To finish editing and save record into database you need do one of:

  • press CMD + RETURN / CTRL + RETURN
  • click by mouse into other record.

Editing Record

To start edit an existed record of table, just click its cell you want to edit. Cell will go into edit mode.

  • existed value will be highlighted and selected, so if you start type then a new value will replace old one.
  • if you do not want erase the old value you can press CTRL + RIGHT or CTRL + LEFT for Windows, or CMD + RIGHT or CMD + LEFT for Mac OS X. This will move the text cursor to the end or to the start of value correspondently.

To finish editing and save record into database you need

  • press CTRL + RETURN / CMD + RETURN.
  • click by mouse into other record.

Delete All Records

To delete all records of the current Table using Data Editor, choose command in the menu [ Record → Delete All Records].

 

Delete Record(s)

This command allows you to delete one or few records at once.

If you have single record selected (it is marked also then) then this command delete it.

If you have few records marked then these records will be deleted

Go to Parent Record

This feature allows you to jump to a parent record using value of the Foreign Key or ObjectPtr fields. [Valentina Studio Pro]

You can use it in one of the following two ways:

  • open the context menu on the value of the FK or ObjectPtr field and select Go To Parent Record:

  • ALT + Left Mouse Button click on the value of the pointing field

Parent table will be opened with the filter row added for the key field.

This command works in the related table as well.

Multiple Update

This feature allows you to set a value to one field of all shown records. [Valentina Studio Pro]

You can use it in one of the following two ways:

  • open the context menu on the value you want to set to all records and select Set For All Records (or Set For All Filtered Records if a filter is applied):

  • open the context menu for the target field and select Update Value To… and input the desired value:

Depending on the current mode, these actions will update:

  • all records of the table
  • filtered records
  • shown set of records, if some records were hidden

This command works in the related table as well.