Table Editor

The Table Editor can be opened on database tables by selecting the Open/Open With Table Editor Action from the context menu of the Tables View respectively by double clicking the table element. It consists of two pages:

the Table Page which can be used to inspect or update the table cells and
the Log Page that collects all insert, update and delete statements that the Table Editor executes as the result of your interaction.

Content Filter

The Table Page has a Filter Area that can be made visible or hidden by the shortcut key sequence Ctrl+Shift+E. It is useful for typing specific filter expression that will be appended to the simple sql full-select statement the Table Editor uses to get the content of the database table. If you type the expression col1>0 and col2 like '%help' for instance the complete statement might look like select * from table1 where col1>0 and col2 like '%help'.

Sort

To sort the table you simply have to select the columns header you want to sort by with the mouse. The sorting is done by the database. It is a current limitation that columns can not be sorted if the database does not support sorting them. That can depend on the general or a data type specific lack of a support of sorting.

Execution

The execution of generated statements must be confirmed if the appropriate preferences are turned on (see DbEdit preferences). The Confirmation Dialog contains the columns of the table displayed in the editor which can be forced to exclude from the generated statement.

Table Page Actions

DoubleClick	A double click on a single cell switches that cell into edit mode. (see F2)
Click on a Column Header	The first click on a columns header switches the sort type for this column into ascending mode. The second click on the same columns header switches into descending mode. The third click removes the sort mode from this column. If column headers are clicked while there are other columns already in sort mode, then this columns are the sort keys number two, three and so on, up to 9.
Click on the Row Numbers Column Header	A click on the header of the row number column resets the sort mode for all other columns.
Ctrl+Shift+E	Makes the Filter Condition visible in a separate text field above the table rows. The value entered here must have the form of a boolean expression, i.e. col1 > 0 and col2 like '%help'. A value change will only be recognized if the Enter key was pressed.
INS	Inserts a new row that can be edited by typing values into the cells. By default the most left column will be switched into edit mode while pressing Enter changes to the next cell. If the Enter-key is pressed in the cell of the most right column the insertion will be submitted to the database.
DEL	Deletes the selected rows.
Ctrl+F	Searches for a specific string.
F5	Refreshes the content of the Table Editor.
ESC	Cancels the currently running refresh operation.
F2	Switches the cell of the currently selected row that matches the horizontal mouse cursor position into edit mode.
Ctrl+Arrow Up	In edit mode the next cell above the current cell is selected.
Ctrl+Arrow Down	In edit mode the next cell below the current cell is selected.
Ctrl+Arrow Left	In edit mode the next cell left of the current cell is selected.
Ctrl+Arrow Right	In edit mode the next cell right of the current cell is selected.
Ctrl+INS	Copies the contents of the selected rows to the clipboard.

Log Page Actions

Ctrl+INS	Copies the contents of the selected rows to the clipboard.

Table Editor

Content Filter

Sort

Execution

Table Page Actions

Log Page Actions