Subject ANN: Database Workbench 2.4.2 released
Author Martijn Tonies
Ladies, gentlemen,

Upscene Productions is happy to announce the next
version of the popular database development tool:
Database Workbench 2.4.2 has been released today!

Download a trial at: http://www.upscene.com
Features and fixes: http://www.upscene.com/news/20040202.htm

Database Workbench supports:
- Borland InterBase ( v4.x - v7.x )
- Firebird ( v1.x )
- MS SQL Server/MSDE ( v7, 2000, MSDE 1 & 2 )
- MySQL 4, 4.1

Also check Bill Todds review in the Delphi Informant:
http://www.delphizine.com/productreviews/2004/01/di200401tb_p/di200401tb_p.a
sp


If you experience any problems with this new version, don't
hestitate and either go to the website and send a support email
or email directly to support@...

Version 2.4.2

New features:
-------------------------------------
Overall
- MySQL 4.1 Characterset/Collation support in Create Database,
tables and columns
- IB/Fb: editable COMPUTED BY columns in the Table Editor
- SQL Editor: added support for '# ' as single line comment
- CSV Export: more export options (text delimiters)
- Export Data: multiple table INSERTs into a single file
- SQL Insight: works with Aliasses (eg: EMPLOYEE E WHERE E.<drop down>)
- DataPump: added "auto-map", will map all tables and matching columns

Database Navigator
- DBNav: added "INSERT INTO (with parameters)" to "More DML"

Fixes and enhancements:
-------------------------------------
- Enhancement: Improved datatype reporting for ADO and ODBC
- Enhancement: Improved "transaction capable" check in ODBC connectivity
- Enhancement: Rewritten "catalog" stuff, including now a "Rename group"
and unlimited levels of nesting
- Enhancement: Multiple enhancements to the Visual Query Builder
- Enhancement: Added more options to the Schema Migrator
- Enhancement: MSSQL: system tables shown in the DBNavigator
- Bugfix: TestDataGenerator: "till date" wasn't inclusive
- Bugfix: TestData: fixed some "street" data without streetname
- Bugfix: CSV Export: Boolean columns weren't written
- Bugfix: Debugger: 'NOW' didn't work for date/time assignments
- Bugfix: Debugger: fixed an error with a particular IF..THEN construct
- Bugfix: BLOB Editor: HTML without a <HTML> tag was displayed as plain
text.
DBW now automatically adds the <HTML> tag
- Bugfix: Several bugfixes to the Visual Query Builder
- Bugfix: DBNav: "refresh" with a Table Editorr open would return an error
(MS, MySQL)
- Bugfix: Schema Migrator: error fixed when leaving "including constraints"
checked when the source is ADO or ODBC
- Bugfix: Schema Migrator: removed another cause for AVs
- Bugfix: IB: removed (possible) AV when dropping PK from the DBNavigator
- Bugfix: IB/Fb: db statistics was always done with SYSDBA instead of
entered user
- Bugfix: IB/Fb: made "generator" values Int64, avoiding overflows
- Bugfix: IB/Fb: fixed the AutoInc Wizard when adding a column, didn't work
- Bugfix: IB/Fb: fixed an error with simulated "alter view" that could
result in view errors
- Bugfix: Fb: descriptions on procedures were extracted with the
wrong statement terminator.
- Bugfix: MySQL: removed two AVs when migrating from ADO/ODBC to MySQL
- Bugfix: MySQL: fixed delimited identifiers in columns: weren't delimited
- Bugfix: MSSQL: removed a possible cause for AVs when closing connections
- Bugfix: MSSQL: fixed a problem with long source in a trigger not being
loaded properly
- Bugfix: MSSQL: Table & View Editor weren't automatically "uppercasing"
columns when required
- Bugfix: MSSQL: fixed a problem with creating COMPUTED BY columns and
"no datatype" message
- Bugfix: MSSQL, MySQL: commented parameters not being taken out




Thank you your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions
http://www.upscene.com