Downloads

Active Query Builder ActiveX Edition History

July 01, 2019

Active Query Builder ActiveX Edition v.1.29.6

= New server versions are listed now for MySQL, MS SQL, Oracle syntaxes.
= Link Properties Form: The single-line expression editor has been replaced
  with a memo field.
- Visibility of the UnionNavBar is restored correctly now after updating 
  the UnionTabSheet params.
- SAP SQL Anywhere: Loading of objects for a non-privileged user has been
  fixed; modern views are used now for v.17 and higher.
- Universal Syntax Provider: The detection of database and schema namespaces
  usage is performed now. It now works fine with the Absolute DB.
- SQLite: Union operators list has been fixed.

May 08, 2019

Active Query Builder ActiveX Edition v.1.29.4

+ Dutch localization has been added.
+ The Query Structure Tree is improved. It is more sensibly organized and 
  allows performing various actions with nodes using context menus. 
= MS SQL Server: Objects from linked servers without database or schema
  support are retrieved fine now.
= MySQL: The default server version is set to 8.0.
= Pervasive: Parsing of some built-in functions has been fixed.
= Minor SQL formatting fixes and improvements have been made.
= PostgreSQL: "table.*" is accepted now as an ordinary row expression term.
= NexusDB: The list of reserved words has been updated.
= SAP Hana: Support for missing functions has been added: LEFT, RIGHT and
  (REPLACE/SUBSTR/OCCURRENCES)_REGEXPR.
- Scaling issues have been fixed.
- The bug with not switching to the new subquery on creating a Derived Table
  has been fixed.

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.