What's new in DbEdit 1.0.1

Installation
SQL Editor/ Instant SQL View
Major changes have been applied to the Core that enables the SQL editor to analyze SQL syntax while typing and annotate errors in text or overview ruler. This feature is very nice but unfortunately the SQL dialects out there are fairly different. Configuration of datatypes and functions that areAnnotations considered by the analyzer will follow in a future release, for now you can only disable analyzation if you do not like the syntax error annotations.



Completion has also been improved/bugfixed to support you with the full SQL dialect that is built in the code as well as any kind of database element (schemas, tables, columns, constraints, indizes).

Another nice addition are query templates that you can freely configure using the SQL editor preference page. CompletionThey work nearly the same as you know it from the Java editor. In addition, backstep positions that you define are recognized by the the completion so that a select statement template as you see it in the screenshot can be used to first choose a table or view to select from and then choose the appropriate columns from these tables or views.


Last but not least are Comment/Uncomment actions that you can use as usual when you select a block of text and hit Ctrl+Shift+/ or Ctrl+Shift+\.

Tables View
For connections the explicitly choose a catalog in the URL, e.g. jdbc:postgresql://host:port/testdb all catalogs were displayed in the past which has been changed. If you want switch back to the old style you can choose Show all Catalogs from the view menu.


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