Subject ANN: InterBase Workbench 1.3.5 released!
Author Martijn Tonies
Hi ladies, gentlemen,

Upscene Productions is happy to announce a new version of
InterBase Workbench - the developer tool for InterBase and Firebird.

InterBase Workbench gives you an easy-to-use application to create,
edit and extract your database objects, export tables, run scripts,
extract metadata, run ad-hoc SQL statements and much much more...

InterBase Workbench works well on low-bandwith connections because
of extensive caching in the object editors and by using IBObjects -
the best InterBase/Firebird connectivity suite for Delphi and
CPP Builder.

InterBase Workbench supports InterBase and Firebird - download a
trial copy at http://www.upscene.com - go there now!

Version 1.3.5

New Features:

SQL Editor
- Added "Start Transaction" button for those cases where InterBase Workbench
does not recognize an active transaction

Index Editor
- New UI that shows field datatypes & NOT NULL flag

Constraint Editor
- New UI that shows field datatypes & NOT NULL flag

Preferences
- Added name-template for Triggers

Overall
- Firebird: added support for BIGINT datatype (FB >= 1.5)
- Firebird: added support for Universal Triggers (FB >= 1.5)
- Removed 'Get Users' buttons from Role Editor and Grant Manager, for
Classic architectures, register the server and enter the 'isc4.gdb' path

Bug fixes and small enhancements:
Bugfix: Miscellaneous small bugs
Bugfix: Miscellaneous small DataPump bugs
Bugfix: DataPump errors with BLOBs
Bugfix: Bugfixes in the Generator Editor
Bugfix: Fixed disappearing single line comments after save in the Procedure,
Constraint and Trigger Editor. Single line "//" is now supported too.
Bugfix: 'no length' error for COMPUTED BY fields
Bugfix: Excel export didn't export decimals for NUMERIC/DECIMAL columns
Bugfix: DBF export didn't work properly
Bugfix: Firebird: CURRENT_USER (and others) defaults was quoted in DDL for
Domains
Enhancement: Primary Key constraint information extracted together with
Table DDL
Enhancement: "Apply Edit" button added in the BLOB Editor
Enhancement: Miscellaneous interface improvements
Enhancement: Changed DataPump file format
Enhancement: Update documentation for command-line Test Data Generator and
DataPump

Version 1.3.1

New features:

Data Pump
- Views can be used as a source
- Ability to use non-registered InterBase/Firebird databases
- Improved loading/saving (including connection details)

Database Navigator
- Ability to edit and save object descriptions
- Added 'Reset All Generators'
- Added 'Re-compile Procedure' and 'Re-compile All Procedures'

Procedure Editor
- Added a simplified SQL Editor to test Execute Procedure results in the
same transaction

Bug fixes and small enhancements:
Bugfix: Fixed Firebird RECREATE error
Bugfix: Search Database didn't search the View source code, double click a
view wouldn't open the editor
Bugfix: Fixed several errors in the Table Editor causing Access Violations
and other exceptions
Bugfix: Find Object in the Database Navigator caused Access Violations
Enhancement: Improved error-handling in the Data Pump
Enhancement: Auto-show Server Output window when running Scripts (See
Preferences)
Enhancement: Improved speed of Test Data Generator by about 10-25% on
(larger) char-columns and 10% in general

Version 1.3

New features:

SUID Procedures
- Easily create Select, Update, Insert and/or Delete Procedures
- Use (optional) existing generator, or create a new one while creating the
Insert Procedure
- Names are generated from Name Templates, see Preferences, but can be
adjusted

BLOB Editor
- View and edit text and binary BLOBs.
- View and edit as Text, Hex values, Image or OLE Object
- Supported image types: Bitmap, Metafile, Icon, JPEG

Data Pump
- Transfer data IB/FB <-> IB/FB
- Transfer data IB/FB <-> ODBC
- Transfer data IB/FB <-> ADO
- Transfer data ODBC <-> ODBC
- Transfer data ODBC <-> ADO
- Transfer data ADO <-> ADO
- Ability to save table/column mappings
- Ability to order data, apply a custom WHERE clause on source data
- Ability to use constant expressions for destination tables (generators,
strings, numeric values)
- Automatic (fuzzy) matching of column names
- Runs in a seperate thread - you can continue working while transferring
data

Test Data Generator
- Ability to run in a seperate thread - you can continue working while
generating data (remot connections only!)
- Save/load Test Data Generator settings
- Much more on screen progress indication and error reporting

Enterprise Manager
- Database Statistics added - analyzes the DB statistics into a
grid-overview
- Database Sweep added

Database Navigator
- Compute Index Selectivity or all Indices (Database Popup Menu)
- Create intelligent SUID Procedures for Tables (right-click Popup Menu)
- Reset generator from context menu
- Added "Run Procedure" to Stored Procedure Popup Menu

Procedure Editor
- For parameter datatype, you can select a domain and the datatype
information will be copied (can be turned ON/OFF in the Preferences)
- Added "Data" tab for selectable procedures
- Added "Execute Procedure"
- Ability to Run the procedure (select or execute)
- Ability to save and load a procedure to/from a file for later editting

Trigger Editor
- Ability to save and load a trigger to/from a file for later editting

Table Editor
- Support for Column descriptions

SQL Editor
- Statement History for keeping track of your SQL statements

Bug fixes and small enhancements:
Bugfix: Fixed not showing/readonly the object description in the Table
Editor, Index Editor and Trigger Editor
Bugfix: Fixed (unneeded) extracting the DEFAULT and COLLATE clause in the
Table Editor DDL tab
Bugfix: Fixed a metadata extract error from the Table Editor (no FKs,
indices etc)
Bugfix: Fixed a 'list index out of bounds' when creating new triggers with
the Triggers node expanded on a table/view
Bugfix: Fixed memory issues with exporting large result-sets
Bugfix: Fixed Role Editor not re-fetching any newly created users
Bugfix: ctrl+shirt+C didn't (un)comment in the Script Editor
Bugfix: Exceptions weren't included in database metadata extract
Bugfix: Bugfixes related to UNICODE and data-exporting
Bugfix: Some minor bugfixes
Enhancement: Changed Backup/Restore project fileformat to be valid XML
Enhancement: Small Grant Manager improvements & fixes


Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com