Downloads

Active Query Builder ActiveX Edition History

March 05, 2008

Active Query Builder ActiveX Edition v.1.9.0.1

+ The new Universal Syntax Provider is added to the Free version (xsUniversal). 
  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 (xsAuto)
  in case of necessity to detect database server automatically.  
* ANSI SQL/92 Syntax Provider has been removed from the Free version.
* Most of the demo projects are modified to work with Universal Syntax Provider
  by default.
+ PostgreSQL query properties form is added.
- PostgreSQL syntax: Fixed problem with double VARCHAR generation for 
  built-in types.
- PostgreSQL syntax: Added support for "/* ... */" comments that were
  erroneously parsed as user-defined operators "/*" and "/*".
- DB2 Syntax now treats "@" and "#" as valid identifier characters.

February 22, 2008

Active Query Builder ActiveX Edition v.1.8.5.11

- The pregenerated LPK file and links to Microsoft site about licensing
  ActiveX controls are added to the HTMLDemo.
+ Minor changes in the installer.

January 24, 2008

Active Query Builder ActiveX Edition v.1.8.5.9

- QueryBuilder didn't regenerate SQL on syntax provider change. Fixed now.
- Now QueryBuilder clears checks marks on selected fields on syntax provider
  change.

January 23, 2008

Active Query Builder ActiveX Edition v.1.8.5.8

- DB2: The missing aggregate functions Avg, Count, Count_Big, Grouping were added.
- Oracle syntax: The erroneously added aggregate functions Count_Big, Checksum_Agg
  were removed.

January 12, 2008

Active Query Builder ActiveX Edition v.1.8.5.6

+ Firebird: Added support of CTE expressions for Firebird 2.1.
+ Uninstall wizard is added to the installation package.

December 27, 2007

Active Query Builder ActiveX Edition v.1.8.5.3

- Minor fixes in the installation package were made.

December 24, 2007

Active Query Builder ActiveX Edition v.1.8.5.2

+ The new property IActiveQueryBuilderX.UsedSQLSyntax is added to retrieve the
  actually used SQL syntax provider when using the auto detection of database
  server (SQLSyntax = xsAuto).
- AQB didn't allow to select the expression for output on some stages of building
  queries with grouping. Fixed now.

December 18, 2007

Active Query Builder ActiveX Edition v.1.8.5.1

+ Unicode support in the Columns pane and in all the Properties windows is 
  implemented. (the rest of visual controls were already Unicode compatible
  before)

December 13, 2007

Active Query Builder ActiveX Edition v.1.8.0.13

+ SQL2003 syntax: The CURRENT_DATE, CURRENT_TIME and LOCALTIMESTAMP constants
  are supported now.
+ Firebird syntax: Common table expressions are supported now.
+ Appliance of the ObjectPrefixSkipping property to the drop-down list 
  of database objects in the Columns Pane is made.
- Fixed falling into the recursion when using an unaliased query with ORDER BY
  clause, if the select item alias is specified in the ordering list.

December 07, 2007

Active Query Builder ActiveX Edition v.1.8.0.12

- The bug with getting AV on clicking the Apply button of Properties window is 
  fixed.
+ Oracle syntax: QueryBuilder now has support of Oracle specific types.