Downloads

Active Query Builder WinForms Edition History

April 04, 2008

Active Query Builder WinForms Edition v.1.5.7.98

- Bug in metadata filters is fixed.

April 03, 2008

Active Query Builder WinForms Edition v.1.5.7.97

+ Sleep mode is implemented. This mode allows you to suppress error messages
  while printing unsupported statements in SQL text editor, connected with
  Active Query Builder. Active Query Builder now switches to Sleep mode when
  non-SELECT statement is passed to the SQL property. This allows your end-users
  to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ...,
  ALTER ..., etc., without any additional processing. 
+ New properties are added to parenthesize conditions in WHERE clause.
+ DB2, MS SQL, SQL2003 syntaxes: Added support for field aliases for derived
  tables.
- MSSQL syntax: WITH clause is fixed.

See the full story for details

March 31, 2008

Active Query Builder WinForms Edition v.1.5.6.96

- DB2 syntax: Bug with correlation clauses is fixed.

March 27, 2008

Active Query Builder WinForms Edition v.1.5.5.94

- MySQL syntax: Missing implementations of "YEAR", "MONTH", "DAY", "HOUR", 
  "MINUTE", "SECOND" and "MICROSECOND" functions are added.

March 25, 2008

Active Query Builder WinForms Edition v.1.5.5.92

+ The new HideSingleDatabaseNode property is added to the
  QueryBuilder.MetadataTreeOptions to hide unnecessary database node if all
  objects are loaded from the same database.
+ New properties are added to the Universal syntax provider:
  AutoDetectServer: Boolean; allow/deny database server autodetection. 
  PreferredServer: TacUniversalSyntaxServerType; defines database server to
  start the autodetection routine from.
  UsedServer: TacUniversalSyntaxServerType; determines detected database server.
- DB2 syntax: bug with some keywords that were used as identifiers is fixed.

March 21, 2008

Active Query Builder WinForms Edition v.1.5.4.91

+ Query properties dialog for PostgreSQL syntax is implemented.
+ Firebird syntax: common table expressions are supported now.
- MS SQL: Fixed loading of database list under a restricted user role.

March 19, 2008

Active Query Builder WinForms Edition v.1.5.3.90

+ Tne new demo project is added to illustrate ability to modify queries
  programmatically (QueryModificationDemo).
= Minor optimizations are made.

March 18, 2008

Active Query Builder WinForms Edition v.1.5.2.79

+ The new syntax provider UniversalSyntaxProvider is added. 
  It is based on the ANSI SQL/92 syntax but allows to determine most of popular
  database servers, successfully retrieve metadata and apply specific settings
  for them to let the user build simple queries for these servers.
  Please note that this does not mean that the Universal Syntax Provider could
  be a suitable replacement for specific database syntax providers, as it
  strictly follows the rules of ANSI standard, that may lead to many 
  incompatibilities while working with specific database servers. 
  Working with the Standard version, use the Auto Syntax Provider in case of
  necessity to detect database server automatically.
+ The new full-featured MDI Demo application with source code is added to the
  Trial and Standard versions.
- Drawing of visual join link arrows is fixed.

March 11, 2008

Active Query Builder WinForms Edition v.1.5.1.78

- Fixed wrong field names quotation in the drop-down list of "Expression" column.
- The bug with relations in PostgreSQL syntax is fixed.

March 05, 2008

Active Query Builder WinForms Edition v.1.5.0.77

+ The new QueryBuilder.MetadataTreeOptions.EnableEditing property is added to
  enable in-place editing of alternate names in the metadata objects tree.
- Minor bug fixes are made.