Editor Preferences

Table Editor

Option
Description
Default
Display binary values as strings
If this option is turned on , then the Table Editor displays the values columns of a binary type as strings rather than in the hex format.
Off
Insert default values
If this option is turned on, then if you start the insertion of a new row (Insert key) the values of the added row will be prefilled with the default values of the database table columns. If  there is no default value defined, then one of the following action is chosen:
  • if the column is nullable, then SQL NULL is the default
  • if the column is not nullable and not unique, the default is '0' , or 0 for numeric data types
  • if the column is unique, then the default is chosen from a distinct select over this column, while the greatest value from the result  is  added to 1 for numeric data types respectively the last character is added to 1 for character data types.
On
Automatically refresh complete editor on update
If this option is turned on, after an insert, update or delete operation the editor is refreshed. The only reason to turn of this option could be very large tables.
Tip: A better alternative for large tables is to apply a filter. That speeds up the refresh operation while not restricting the Table Editor's functionaliy.
On
Show row numbers This option switches the visibility of the row number column.
On
Make use of referential information
If this is option turned on, then for each foreign key column of a database table the Table Editor creates a combo box if the corresponding value should be edited (Edit Mode). The combo box is prefilled with all values from  the primary key column the foreign key refers to. Because the values are retrieved using a single column select the sort order depends on the database. That is why currently for keys that are composed of more than one column you cannot rely on the combo box value index when choosing values that refer to the same key.
On
Consider the string literal as SQL NULL
This string will be displayed if a value is SQL NULL. Furthermore if this value is typed into a cell when updating, the Table Editor would submit SQL NULL to the database.
The only reason why this should be changed is if a value is not  SQL NULL but '<NULL>'.
<NULL>
Maximal row count This value sets a limit on the Table Editor to stop refreshing if the specified row count has been read. As the refresh operation can be stopped by using the Cancel action, normally there should be no need to set a value here.

Initial column width
This value sets the column width of the Table Editors columns. If not specified, the columns will automatically be resized to fit their content.
Tip: By using the action Resize columns to fit the columns can be resized at any time.

Separator between columns for copy operation
This value will be inserted between the column values when copying the contents of the Table Editor by using the Copy operation.


SQL Editor




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