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:

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'.


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.


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

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.
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.
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.
Deletes the selected rows.
Searches for a specific string.
Refreshes the content of the Table Editor.
Cancels the currently running refresh operation.
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.
Copies the contents of the selected rows to the clipboard.

Log Page Actions

Copies the contents of the selected rows to the clipboard.

© Copyright Uwe Voigt 2002, 2003, All Rights Reserved.