Example: If you have pasted a statement like select alpha from beta; into an SQL part where beta is a table that resides in schema gamma, using completion on one of the elements lead to no results. Now, if you logged on the database with user gamma, you can use completion on each of the elements.
When content assistance for tables is requested DbEdit now inserts the identifier elements without quotes by default. If you want the quotes because the identifier is a keyword or it must be case sensitive, you can force it by pressing the Shift button. Using the SQL Editor preference page you can also switch back to the previous behaviour.
Following a user request the SQL capable parts now support multiline comments using the entry sequence /* and the end sequence */.
There is a new toolbar addition which enables you
to scroll forward and backward through the result set (Ctrl+Alt+Page Down/Ctrl+Alt+Page Up). Please note
that, if your specific JDBC driver doesn't support scrolling, each
attempt to scroll backward will lead to a new execution of the select
statement associated with the result part. You must also know that if
the driver does support scrolling, the new page you'll see
after scrolling forward or backward can differ from the content of the
table in the database which might have been changed by another user or
program.The SQL result parts now support different encodings. To achieve this, DbEdit first converts the strings retrieved from the JDBC driver to the Unicode format and then to the chosen encoding.To select one of the predefined encodings or enter a special one press the third button in the result toolbar.
Two new functions have been added to the context menu. Copy as Inserts copies the selected rows as insert statements to the clipboard. Paste Row appends a new row similar to the function Insert Row but the values are prefilled with the content of the clipboard that may be a previously copied row (use Copy Row(s) here).
When making use of referential information, the table
editor now presents a more sophisticated combo box than
before. It can be used to either select values from the list or to
search in the list as known from the Open Table Dialog. The values
presented within the box are added somewhat slow so for
large referenced tables it might be generally better to restrict the
search by entering a few characters. When opening a table it might take
a few seconds until values are available because the operation that
fills the combo box is deferred.Please use the Refresh Reference Values button if you want the actual content be filled within the boxes.
