Major icons enhancement:

Added features:

Via menu items Save results from table as .. and Save results from query as.. you can save the content of the grid in the file.
You can choose delimiter for fields, delimiter for string fields and add column names as first line in the file.

The view of sql marks was changed. A new property of connection was added: zeroDateTimeBehavior.

Added features:

  • The view of sql marks was changed. Now you can see the queries as tooltips, so the tree gets more readable.

Bugfixes:

  • A new property of connection was added: zeroDateTimeBehavior. This solves the problem - datetimes with all-zero components (0000-00-00 ...) throwing an exception e.g.: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column xx to TIMESTAMP.

Added features:

  • The limit input box from the main toolbar was moved to the tab Content of table.
  • New buttons were added to the tab Content of table allowing to change data via grid - Insert, Update, Delete, Commit and Rollback buttons.

 

Added features:

  • You can add parameters in your queries in the SQL Console and save these sqls in the sqlmarks.
  • Useful system sql marks.