Subject ANN: InterBase Workbench v1.3 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.

This version includes support for the latest Firebird features!

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 - go there now!

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

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

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
- 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

Upscene Productions