VERSION HISTORY

 January 22, 2010 version # 3.11

Issues Addressed

#740

Fixed bug in Versoin Updates (allow 0 as a valid minor version, e.g. 2.0).

#741

Fixed bug in DBISAM (3 & 4), NEXUS 1 and Absolute Database adapters (SystemTableName was not assigned correctly).

 January 20, 2010 version # 3.10

Improvements

#732

Improved Schema Consistency Test. Added check and automatic problem resolution for invalid object names.

#733

Improved reverse engineering of stored procedures for Interbase and Firebird.

 January 12, 2010 version # 3.09

Issues Addressed

#714

Fixed bug in dbSQLParser.pas (ExtractTableName method should extract quoted TableName from Triggers definition).

#715

Fixed bug in TDBEngineProfile.ReverseEngineer (auto detecting parsing field).

#716

Improved dbSQLParser.pas, added support for FullName property.

 December 28, 2009 version # 3.08

Improvements

#709

Added support for DBISAM 4 under Delphi 2009 & 2010.

 November 30, 2009 version # 3.07

Improvements

#701

Added IndexExpression and IsExpression properties to the TIndexDefinition class.

 November 17, 2009 version # 3.06

Issues Addressed

#690

Fixed bug in dbLexer (incorrect state restoration after an attempt to parse comments).

Improvements

#685

Improved SQL DDL parser allowing to skip eoln-terminated statements (e.g. pragma PROMPT in Oracle).

#694

Added UniqueConstraint property to TIndexDefinition class.

#695

Changed SQL generation method (now generating drop clauses first).

 October 30, 2009 version # 3.05.2

Issues Addressed

#684

Fixed bug with SQLLexer going into infinite loop under Delphi 2009/2001 due to Unicode problems.

 October 29, 2009 version # 3.05

Issues Addressed

#681

Fixed some minor bugs in TDatabaseSchema and TDBSchemaTester components.

Improvements

#667

Added support for Delphi 2010.

 August 5, 2009 version # 3.04

Improvements

#656

Added collection of SQL scripts stored in the database schema. Each script can be executed conditionally on selected events such as (Before Update, After Update, Before Updates, After Updates) and also appended to generated SQL script before and/or after Create and/or Drop.

 July 25, 2009 version # 3.03

Issues Addressed

#595

Fixed bug with sequences not being cleared when a schema is assigned from schema, which has no sequences defined.

 July 13, 2009 version # 3.02

Improvements

#592

Views are now stored in the same collection with tables and have all of the table's properties, including fields, indexes, foreign keys, etc.

#593

Added SystemTableName which allows to have several independent schemas within a single database

#594

Added components for disconnected mode (TCtxDataContainer, TCtxDataSet, TCtxDataCommand, TCtxDataAdapter, TCtxCommandBuilder)

 June 26, 2007 version # 2.15

Improvements

#569

Added support (design-time package) for Delphi 2007 for Win32.

 April 27, 2007 version # 2.14

Issues Addressed

#542

Fixed problem with domains not being imported during reverse engineering.

Improvements

#530

Modified ICtxDatabase interface to better support parametrized queries.

 February 14, 2007 version # 2.13

Issues Addressed

#499

Fixed minor problems in SQLPraser (dbSQLParser.pas unit).

Improvements

#498

Starting from this version, all extended adapters are provided as separate downloads due to increasing number of supported databases.

 December 18, 2006 version # 2.12

Improvements

#481

Fixed minor bugs. Added FIBPlus adapter.

 October 9, 2006 version # 2.11

Improvements

#479

Added CustomObjects collection to TDatabaseSchema.

#480

Improved Interbase\Firebird adapter.

 August 24, 2006 version # 2.10

Improvements

#446

Added Sort method to TSchemaItemsCollection. This allows alphabetical sorting of schema collection items by name.

 August 15, 2006 version # 2.09

Issues Addressed

#433

Fixed minor problem in SQL import.

Improvements

#432

Added ComputeAs property to TFieldDefinition.

 July 24, 2006 version # 2.08

Improvements

#425

Added remote port to DBISAM4 DatabaseURL. It can now take server name in form :.

 June 26, 2006 version # 2.07

Issues Addressed

#409

Fixed minor problems is sql import.

 June 21, 2006 version # 2.06

Improvements

#408

Restored StartTransaction method interface for dbisam 4.

 May 31, 2006 version # 2.05

Improvements

#393

Added select stataments execution to IDE interface.

#394

Added DSDFileName property to TDatabaseSchema (design-time only).

#395

Added LibVersion property to TDatabaseSchema (design-time only).

 May 9, 2006 version # 2.04

Improvements

#381

Improved connectivity with schema component in IDE.

#382

Published collections made read-only for TDatabaseSchema. This prevents schema objects from being modified from IDE.

 April 12, 2006 version # 2.03

Issues Addressed

#357

Fixed problem with TDbMemDataSet incorrectly writing Blob data when saving to binary file.

#360

Fixed few minor problems with SQL generaion (TDBEngProfile component).

Improvements

#358

Added support for Delphi 2006.

#359

Added Nexus 2 adapter.

 December 20, 2005 version # 2.02

Improvements

#336

Added dbSQLLexer unit, with generic SQL lexer & parser implementation. This allows and run complex scripts SQL scripts against engines, that do not support multi-statement batches.

#337

Changed the model of relationships implementation. All relationships are stored within Relationships collection of TDatabaseSchema. Each table also contains TRelation objects (compatible in interface with same TRelation(s) in prior releases of extensions) build automatically from TRelationship(s). This helps avoiding creation of duplicate and mismatching pairs of relations.

#338

Added TTableConstraints collection, holding table level check constraints (TTableConstraint).

#339

Added TIndexFields collection for TIndexDefinition class, holding individual index fields and their extended properties.

 October 31, 2005 version # 2.01

Improvements

#267

Improved Diagram Editor. Added Undo/Redo features, saving to XML and more.

#273

AutoRefreshOnRollback function of TxxxDatabaseExt also refreshes live queries.

#316

Most of the extended client-side functionality, like replication and serialization has been moved to TDBManager component and dbExtUtils unit.

#317

Added TDBEngineProfile component that can be used to generate various SQL scripts based on database engine profile (see .dbp files included with Context Database Designer under 'dbdefs' folder).

#318

TDatabaseSchema component is enhanced to contain for types of metadata, like domains, views, sequences and stored procedures.

#319

Objects contained in schema extended to have custom (user defined & engine specific) properties.

#320

Added generic adapters for BDE, ADO, DBX, IB database access.

 August 31, 2005 version # 1.70

Issues Addressed

#314

Memory leak in TxxQueryExt component.

Improvements

#313

Restored compatibility with DBISAM 4.21

#315

Improved expression evaluator.

 March 23, 2005 version # 1.60

Issues Addressed

#299

Incompatibility with DBISAM v. 4.18

Improvements

#271

Compatibility with Delphi 2005

#272

Diagram Editor form resizing under Large Fonts.

 November 22, 2004 version # 1.50

Issues Addressed

#252

Incompatibility with DBISAM v 4.14 due to missing defines.

#254

Bug in GetFieldData method of TDBEnumeration causing A/V with DevExpress Controls.

Improvements

#253

Added ShortDescription property to enumerations.

#255

Improved table resizing in Schema Editor.

#256

Added extendable custom properties to field definitions declared in TDatabaseSchema.

#257

Added support for NexusDB Database Engine

#258

Added database related functions (like Reverse Enineering, Restructure, etc.) to Schema Editor.

 June 28, 2004 version # 1.31

Issues Addressed

#1

Several issues in Database Schema Editor.

 June 11, 2004 version # 1.30

Issues Addressed

#2

Restored compatibility with DBISAM v.4.08 by using conditional defines in DBISAMExt to remedy changed in StartTransaction method interface.

 March 17, 2004 version # 1.22

Issues Addressed

#3

Bugs in Diagram Schema Editor

#4

Minor problem in Demos, causing erros when working with regional settings where floating numbers are separated by comma ('4,2') rather then by a dot ('4.2').

 February 19, 2004 version # 1.21

Issues Addressed

#5

DBISAMExt unit: Bug in WriteObjectChanges method in TDBISAMDatabaseExt component.

#6

dbSchema unit: Bugs related to assigning different types of objects to each other.

#9

fSchemaEditor unit: Several minor problems in Schema Editor, improved importing functionality allowing importing parts of schema (including tables, enumerations and diagram pages), which makes it easy creating business objects repository.

Improvements

#7

dbRecord unit: Added database independant TDBRecord component that implements a generic one-record dataset that could be used to store form's data in memory. It is usefull to implement forms using only db-aware controls with less coding.

#8

dbSequence unit: Added TDBSequences component implementing generic sequences, that could be used as unque key generators (similar to Oracle's sequences). TDBSequence component is database independant.

#10

Added demos for dbRecord and dbSequences components.

 January 23, 2004 version # 1.20

Issues Addressed

#11

Bug with the transaction not being started before executing some triggers.

#12

Minor bugs in calculations of aggregated fields.

#13

Minor problems in the Schema Editor.

Improvements

#14

Added schema analysis to the Schema Editor to report inconsistencies within schema (dbSchemaTest.pas unit).

#15

Extensively tested compatibility with DBISAM v4.00.

 December 10, 2003 version # 1.19

Improvements

#16

DBISAMExt unit: Added support for TriggerActive property for triggers. This property determines whether the trigger is active always, only during database replication, except during database replication or never.

#17

Changed the way triggers and calculated fields are processed during replication.

#18

Added compatibility with DBISAM V4.

#19

dbSchema unit: Added TriggerActive property for triggers. This property determines whether the trigger is active always, only during database replication, except during database replication or never.

#20

Some of the generic code as well as declaration of IDatabaseExt interface is moved to dbSchema. This allowed to deprecate TDBDocumentStorage component which is no longer required and completely replaced by TXXXDatabaseExt component.

 September 18, 2003 version # 1.18

Improvements

#21

Added support for Expressions in Condition and ForeignCondition fields (before Condition only supported one boolean field)

#22

Added support for auto-calculated sum & count aggregated fields based on expressions. See TFieldDefinition.AggregateExpression property.

#23

Changed the way aggregated fields are described. Now Any field may be defined as aggregate based on a certain relation and expression.

#24

Added count & sum types of aggregate. If aggregate expression is not specified, count will return number of all records '*'.

#25

Relations now allow expressions within Condition and ForeignCondition fields.

 July 17, 2003 version # 1.17

Issues Addressed

#29

Bug in cascade operations for new records. Currently the engine does not process any cascade operations for newly inserted records.

Improvements

#26

Added Save/Load to stream and file methods for table and database. Added Category property for table definitions.

#28

Added property FAutoRefreshOnRollback (default False), causing the database to refresh active tables after rollback of transaction

 April 11, 2003 version # 1.16

Improvements

#27

Added support for macros in TDBISAMQueryExt

 March 4, 2003 version # 1.15

Improvements

#30

Added generation of the Delphi declarations corresponding to enumerations and tables described in the database schema. This functionality is implemented as a Component Editor for TDatabaseSchema component.

 February 16, 2003 version # 1.14

Improvements

#31

Added RestructureFromSchema method allowing to restructure the database according to the information, conatined in schema without loosing data.

#32

Added support for enumerations, declared in schema. Enumerations can now be exposed, by TDBSchemaEnum or TDBEnumeration components and used to provide value for lookup fields.

#33

Added components supporting Document-Journal processing model: TDBDocument, TDBDocumentType, TDBJournal, TDBDocumentStorage and TDBISAMDocumentStorage.

 February 7, 2003 version # 1.13

Issues Addressed

#35

Spelling errors in error messages.

Improvements

#34

Added suport for DefaultExpression property.

 January 31, 2003 version # 1.12

Issues Addressed

#36

Problem with the field Abort of TProgressCounter not properly initialized.

#37

Problem with invalid CRLN and debugging under D6/7.

 January 16, 2003 version # 1.11

Issues Addressed

#38

Severe (!) problem with reading field maps from data exchange file (method ImportChanges). Problem resulted in 'No field name found for table ...' error.

 January 10, 2003 version # 1.10

Issues Addressed

#39

Problem with Temporary tables (property Temporary = True) not being destroyed when the component is destroyed upon closing the form.

 January 7, 2003 version # 1.09

Issues Addressed

#40

Problem with failing to set KeyFieldCount when assigning range. This problem resulted in constrained being ignored if the number of fields in index is larger, then the number of fields in key.

 December 27, 2002 version # 1.08

Issues Addressed

#41

Problems with D6&7 compatibility

 November 26, 2002 version # 1.06

Improvements

#42

Finished most of the work on replications

 November 1, 2002 version # 1.05

Issues Addressed

#43

Minor bugs & added replication support features

 October 22, 2002 version # 1.04

Improvements

#44

Added compatibility with Delphi 6.

 October 22, 2002 version # 1.03

Improvements

#45

Included TDBISAMEvents into EBISAMExt package

 October 12, 2002 version # 1.02

Improvements

#46

Improvements made in cascade Delete/Nullify procedures.