Option |
Description |
Default |
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:
|
Off |
Automatically refresh complete
editor on update |
If this option is turned on,
after an insert, update or delete operation the editor is refreshed.
Reasons to turn off this option could be very large tables or slow
connections. 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 functionality. |
On |
Show row numbers | This option switches the
visibility of the row number column. |
On |
Make use of referential
information |
If this option is 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 |
Display binary values as strings by default |
If this option is turned on , then the Table Editor displays the values of columns having a binary type as strings rather than in the hex format. | Off |
Show the table count in the status bar |
If turned on, each time a Table Editor is opened
or refreshed the SQL statement select count(*) from
<table_name> is executed. If the tables you work with are
too large to allow the statement to be executed within a few
milliseconds you should turned this off. |
On |
Prefix to prepend before binary display values |
This prefix string is prepended to binary
display values. In previous releases this has been a constant value of
'0x'. |
Empty |
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. |
|
Incremental fetch count |
This sets the initial count of
rows
that will be fetched from a table. The next rows can be retrieved using
Ctrl+Alt+Page Down or the
appropriate button from the Table Editor toolbar. |
100 |
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. |
', ' |
Default encoding used in result parts |
Within this field you can specify the default
encoding that is used for each new opening table result part. The
specific encoding associated with one table result can later be
adjusted using the toolbar menu. |
platform default encoding |