DbEdit Table Properties


The table property page allows you do change DbEdit's behaviour when dealing with database tables. Any values changed here will be applied to the table object if you press OK or Apply and made persistent in the offline cache. That's why an element that is not offline available prior to changing it's properties will be after as well as its parent elements. In the Tables View a marker prefix ('>') is assigned to elements that's properties have been set, so it is easy to identify later what you have changed.

Select Statement

The upper area contains the statement used when opening the Table Editor. Normally it should look like select <column_list> from <table_name>. You are not restricted to change this statement any way you want. However, for table elements that are not persisted queries you may have created using the SQL Editors Execute Action (Ctrl+Alt+E) it should at least remain a select over the table it describes.
One of the purposes for allowing you to change the statement is the reordering of columns which is not supported by the widget used to show the table content.

Columns

In the lower area there is the list of columns produced by the actually selected statement. As already stated, this list should normally be identical to the list of columns of the database table.
If you select one of the columns, the combo boxes right to the columns list will be updated with values associated to that column.

JDBC Type

You can assign a new JDBC type to the column. The only reason to do this is a difference between the JDBC type and the DDL type, which is the type that was probably used to create the table. Some JDBC drivers report the JDBC type OTHER while there is an appropriate type they could report, e.g. TIMESTAMP. The Table Editor  cannot automatically detect the right JDBC type without assistance. This property page lets you 'override' the data type and provide the Table Editor with that assistance.

Associated Editor

Another combo box lets you associate cell editors to columns other  than the default text or combo box editors. The editors listed here are implementations of the Interface dbedit.ui.editor.table.ICellEditor and are registered using the DbEdit Extension point dbedit.ui.CellEditor.
There are two cell editors listed by default, the Multiline Editor and External Editor. The Multiline Editor supports you with editing of text that has line breaks. The External Editor is an OLE Editor (available on Win32 only) that can be used to edit OLE documents with a specific file type. To choose a file type you have to press the Configure button and select one from the list.



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