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