Downloads

Active Query Builder ActiveX Edition History

January 21, 2019

Active Query Builder ActiveX Edition v.1.29.3

- Turning off grouping in the query via the global Grouping checkbox in the
  header of Query Columns List may lead to inconsistent queries. Fixed now.
- PostgreSQL: Parsing ambiguities for INTERVAL and AT TIME ZONE clauses have
  been fixed.

December 11, 2018

Active Query Builder ActiveX Edition v.1.29.0

+ Initial support of SAP Hana SQL syntax has been added.
+ Initial support of Pervasive SQL syntax has been added.
+ MySQL: Support for Common Table Expressions for MySql v8+ has been added.
+ Now it's possible to add and remove rows in the Query Columns List using
  the Alt+Insert and Alt+Delete keyboard shortcuts, move them up and down
  using the Alt+[Arrow Up/Down] keys.
= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.
+ The new  properties have been added to the ActiveQueryBuilderX object to
  hide the controls for managing subqueries: SubQueryTabsVisible,
  UnionNavBarVisible.
= The behavior of LinkOptions.CreateLinksByIdenticalFieldNames property
  has been changed. Links are created only if one of the fields is a part 
  of the primary key.

November 19, 2018

Active Query Builder ActiveX Edition v.1.28.11

+ MySQL: Support for Common Table Expressions for MySql v8+ has been added.
= Oracle: Support for ranking functions has been updated.
- PostgreSQL: Parsing of the "AT TIME ZONE" clause and "EXTRACT(epoch FROM 
  ...)" function has been fixed.
- MS Access: Parsing of the TRUE and FALSE constants has been fixed.
- The Union Navigation Bar scaling issues have been eliminated. 

September 23, 2018

Active Query Builder ActiveX Edition v.1.28.10

- Minor bugs have been fixed.

July 13, 2018

Active Query Builder ActiveX Edition v.1.28.8

= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
= Pervasive: List of keywords and functions has been filled.
= Pervasive: Support of IF function, LIMIT/OFFSET clause has been made.
- Pervasive: Parsing of date/time builtin functions has been fixed.
- Teradata: The bug with the autodetection of new versions has been fixed.
- SQLite: Parsing of queries with RIGHT and FULL joins throws the parsing
  exception now.
- IBM DB2: NULL is parsed as a constant, not as an identifier.
= The LinkOptions.CreateLinksByIdenticalFieldNames behaviour has been changed.
  Links are created only if one of the fields is a part of the primary key.
= Loading of Primary Key fields has been improved.
= Complex SQL expressions aren't loaded as joins anymore.
- Changing of the link type if RIGHT JOIN is not supported is not allowed now.
- The bug with the height calculation of the UNION navigation bar when the
  query has unions in brackets has been fixed.
- Memory leaks have been eliminated.

March 15, 2018

Active Query Builder ActiveX Edition v.1.28.7

= SQLite: The list of reserved words has been filled.

February 28, 2018

Active Query Builder ActiveX Edition v.1.28.6

= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.

February 22, 2018

Active Query Builder ActiveX Edition v.1.28.5

+ Initial support of Pervasive SQL syntax has been added.
- Links cardinality calculation has been fixed.
- MS SQL Server: Multi-column foreign keys loading for SQL Server 2005 and 
  higher has been fixed.
- MySQL: Support of STDDEV function has been fixed.

January 27, 2018

Active Query Builder ActiveX Edition v.1.28.4

= Index numbers in ORDER BY are converted to corresponding expressions now.
= PostgreSQL parser has been optimized.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  an arbitrary order has been fixed.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.
= ODBC: Fetching of databases and schemas is supported now.

December 19, 2017

Active Query Builder ActiveX Edition v.1.28.3

+ Help strings for new properties have been added.
= MS SQL Server: The DB_NAME function is used now to the get current db name
  on MS SQL Server 2008 and higher.