InterBase Workbench version 1.3.5 released!

[09-02-2002]
The succes story continues - InterBase Workbench v1.3.5, the popular tool for InterBase and Firebird database engines, has been released as a small maintenance and small feature update. This version is a minor upgrade to version 1.3.1 and fixes quite a few bugs. It also introduces some special GUI enhancements and a whole range of internal changes in order to improve support for Firebird. Download your trial copy now or purchase licenses online. Don't fall behind, speed up your development, download InterBase Workbench!

Version 1.3.5

New features:

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

• New UI that shows field datatypes & NOT NULL flag

• New UI that shows field datatypes & NOT NULL flag

• Added name-template for Triggers

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

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

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

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

• 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

• 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

• 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

• 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

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

• 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

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

• Ability to save and load a trigger to/from a file for later editing

• Support for Column descriptions

• 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