What's new in DbEdit 1.0.3

Table Editor
Query result parts display an outline of the columns (Ctrl+O) which can be used to navigate through the columns. The result part itself scrolls to the selected column (Eclipse 3.0 only).Outline

A new property page which is available for connections, catalogs and schemas can be used to associate a special editor to a specific SQL type. This can be used for a number of tables which include VARCHAR values that may have line breaks which are hardly editable by the normal cell editor. You can associate the Multiline Editor to the VARCHAR type for those tables or schemas and affect all columns of that type in the specific scope.
 It is also possible to determine how specific types should be displayed. For instance the SQL type DATE can be 'overridden' with the type TIMESTAMP which causes DbEdit to display such values as timestamps adding a time part to the date. Note that JDBC driver you use may have problems to convert to all types. If a type cannot be converted the resulting value reported by the driver is displayed instead of the column value.

A new Insert Defaults action is supported by the Table Editor which inserts a new row with default values prefilled for all columns. If no default value is associated to the column of the table, then DbEdit inserts either a '0', the next value that could be feasible for columns with a unique index or the current timestamp for time types.
Property Pages
A new property page for container elements like schemas, catalogs or connections has been added. It allows you to 'override' datatypes to can display and edit Oracle timestamps for instance.
It also lets you associate a specific cell editor to a type.

Legal Notice