Downloads

Active Query Builder ActiveX Edition History

October 17, 2019

Active Query Builder ActiveX Edition v.1.29.11

- Minor bugs in the Query Structure Tree have been fixed.
+ Oracle: OFFSET/FETCH support for Oracle 12+
+ PostgreSQL: add DISTINCT ON support
= New properties have been added to ANSI standard and Universal syntax
  providers: IsSupportDatabases and IsSupportSchemas.
= Informix: Support for new built-in functions (LEFT, RIGHT) has been added.
+ Informix: Support for derived tables for IDS11+ has been made.
= Informix: Objects from all schemas can be used without schema prefix.
- PostgreSQL: Comparison operators precedence has been corrected.
= PostgreSQL: Handling of "partial" expressions like "=1" is improved.
- PostgreSQL: Filtration of camel-cased names using QueryTransformer has 
  been fixed.
- Pervasive: The bug with a dot before the table name has been fixed.

July 24, 2019

Active Query Builder ActiveX Edition v.1.29.10

- The bug with an empty schema for generic ANSI SQL syntax providers has been
  fixed.

July 09, 2019

Active Query Builder ActiveX Edition v.1.29.8

- Dot-prefixing objects with an empty schema for servers without database
  namespace support has been fixed.

July 06, 2019

Active Query Builder ActiveX Edition v.1.29.7

+ Query Structure Tree: sub-queries from WHERE and SQL expressions from other
  parts of the query are shown in the tree now.
= AST tree operations have been speeded up.

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.