Downloads

Active Query Builder ActiveX Edition History

July 15, 2022

Active Query Builder ActiveX Edition v.1.31.13

= Oracle: Type precision for NUMBER type is displayed now.
- Pervasive: SQL parser ambiguity in datetime functions is eliminated.

May 19, 2022

Active Query Builder ActiveX Edition v.1.31.12

= MySQL: Support for JSON extraction operators is added.
- Design Pane: Redrawing of datasource field lists is fixed.
- Design Pane: Minor HiDPI drawing fixes are made.

May 06, 2022

Active Query Builder ActiveX Edition v.1.31.11

= The load of conditions with double-negated logical fields, such as "not not
  tbl.LogicalField" is fixed.
= Denodo: The list of built-in functions is updated.
- The bug on calling the EditProperties method on x64 platform is fixed.
- The bug with MFC/ATL applications compiled in 64-bit mode with VC10 compiler
  and higher is fixed.

April 20, 2022

Active Query Builder ActiveX Edition v.1.31.10

- The compatibility issue with MFC/ATL applications compiled by Visual Studio
  2019 and higher is fixed.
= Query Columns List: Logical expressions such as EXISTS subqueries aren't set
  visible automatically, but used for filtration by default.

April 12, 2022

Active Query Builder ActiveX Edition v.1.31.9

= Design Pane: Join type markers in MSSQL-style mode are scaled properly in
  HiDPI resolutions now.
- Query Column List: Row selection and re-ordering by mouse is fixed.
- Query Column List: "=TRUE" is added automatically to the Criteria cell on
  entering logical expressions like "EXISTS" sub-queries.
= MS SQL Server: Support for "FOR JSON" clause is added.
= MS SQL Server: Support of JOIN without type is added. 
- Oracle: Parsing of default value clause for conversion functions is fixed.
- SAP Hana: Parsing of YEAR/HOUR/MINUTE/... builtin functions is fixed.
- PostgreSQL: The DEFAULT token is added to the list of keywords.
- InterBase: The bug with applying limits in the QueryTransformer is fixed.
- SQLite: Extracting DateTime values from the parsed expression is fixed.

February 17, 2022

Active Query Builder ActiveX Edition v.1.31.8

+ SAP Hana: Support for analytic expressions is added.
- MS SQL Server: The TIME built-in type parsing is fixed.
- Pervasive DB: The ambiguity in the IF built-in function parsing is 
  eliminated, so parsing is speeded up.
- Pervasive DB: Parsing of the DatePart keywords as identifiers are fixed.
- The bug with OLE drag'n'drop registration for the select list grid control
  is fixed.

January 19, 2022

Active Query Builder ActiveX Edition v.1.31.7

= Informix: The bug with the impossibility to use some keywords as identifiers
  is fixed.
+ MS SQL Server: Support for the "AT TIME ZONE" operator is added.
- The exception on loading queries with index-referenced columns in ORDER BY is
  eliminated.
- The bug on selecting the "Check all" action in the datasource field list for
  queries with grouping is fixed.
- The exception on re-calculation of datasource control captions in some cases
  is eliminated.

November 11, 2021

Active Query Builder ActiveX Edition v.1.31.6

= Design Pane: Datasources don't grab the focus on mouse hover now.
= MySQL: Fields are fetched sorted by ORDINAL_POSITION now.
= SQLite: A load of foreign keys is improved.
- Metadata Filter: The exclusion filter condition generation for filter items
  with both non-empty SchemaMask and ObjectMask is fixed.

November 01, 2021

Active Query Builder ActiveX Edition v.1.31.5

= Minor internal optimizations were made.

October 29, 2021

Active Query Builder ActiveX Edition v.1.31.4

+ SQLite: Date, Time and DateTime conversion built-in functions are added.
= Firebird: CTE in subqueries are supported now. 
- Oracle: The bug with applying limits for server versions without 
  OFFSET/FETCH support is fixed.
= QueryTransformer: On the select list expansion, column aliases are assigned
  for all fields, not only for renamed ones.
- The access violation error on deleting a datasource from the Design Pane is
  eliminated.