Active Query Builder ActiveX Edition History

June 30, 2021

Active Query Builder ActiveX Edition v.1.30.11

+ The initial support for Denodo Virtual Dataport is made.
= Query Transformer: The fields case is preserved now for a wrapped query.
- Query Transformer: The bug with ORDER BY generation for a wrapped query is
- Automatic generation of short aliases is fixed when the object is added to
  the query from the linked objects menu.
- Metadata object names generation and comparison are fixed when the server
  generally supports schemas, but the server returns an empty schema.
- The bug with not updating the SQL text on editing a subquery in the link
  expression is fixed.
= MS SQL Server: The support for TRY_CAST and TRY_CONVERT built-in functions
  is added.
= Teradata: A fallback to non-X system views is made if X-views are not
- Teradata: The server autodetection is fixed.
- Pervasive: Parsing of the IF, DateAdd, DateDiff, and DatePart built-in
  functions and the DOUBLE built-in type are fixed.
- DB2: Parsing of the EXCEPTION JOIN and backslash as a division in
  expressions are fixed.
- SAP Hana: The IsSupportDatabase flag is turned off.

March 10, 2021

Active Query Builder ActiveX Edition v.1.30.10

= The length of automatically generated aliases for single-word names is 
  set to 3 characters; the maximum length is limited to 5.
- MySQL: "PRECEDING" and "POSITION" clauses are fixed.

February 04, 2021

Active Query Builder ActiveX Edition v.1.30.9

+ The component generates short object aliases for objects added to the
  query if the ActiveQueryBuilderX.GenerateShortObjectAliases is set to True.

February 02, 2021

Active Query Builder ActiveX Edition v.1.30.8

= SAP HANA: Support for the CONVERT_UNIT built-in function has been added.
= MySQL: Support for UTC_DATE, UTC_TIME, UTC_TIMESTAMP functions has been
= MySQL: Parsing of the RECURSIVE keyword in the WITH clause has been fixed.
= MS Access: Parsing of optional identifier before subquery in the FROM
  clause has been fixed.
= NexusDB: Remote NexusDb server dependencies have been removed from the
  metadata provider.
- QueryTransformer: Multi-level filters have been fixed.
- acCriteriaBuilderListPopup: The bug on pressing the Esc key has been 
- The Access violation exception on loading complex query with ORDER BY
  column indices has been eliminated.
- PostgreSQL: The PRECISION token has been added to the list of valid

December 21, 2020

Active Query Builder ActiveX Edition v.1.30.7

+ Support for the QuickBooks SQL syntax is added (xsQuickBooks = 140)
= PostgreSQL: Support for parenthesised subqueries has been added.
= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- MySQL: The bug with the special syntax of POSITION has been fixed.

August 08, 2020

Active Query Builder ActiveX Edition v.1.30.6

- MySQL: The bug with adding "=TRUE" or "=FALSE" for logical expressions has 
  been fixed.
- MySQL: The Tilda character "~" is removed from the set of valid characters
  for identifiers.
- SAP Hana: TOP, DISTINCT, and PLACEHOLDER clauses are generated at the right
  place and order now.
= OCX registration script is available for different platforms now. 

June 17, 2020

Active Query Builder ActiveX Edition v.1.30.5

= Minor improvements have been made.

June 11, 2020

Active Query Builder ActiveX Edition v.1.30.4

+ Users now can create links from UI separately indicating the beginning and 
  end field via the datasource field context menu.
+ The new property ActiveQueryBuilderX.SwapSidePanels has been added to swap
  the Database Schema Tree and the Query Structure Tree.
= PostgreSQL: Backslash quotation for generic string literals has been removed.

May 22, 2020

Active Query Builder ActiveX Edition v.1.30.3

= Design Pane: Datasource captions are made more contrast.
= Usability of building queries with grouping has been improved by a series
  of small fixes.
+ Oracle: params and fields for stored procs, table functions loading fix
= Oracle: Synonyms are loaded faster now.
- Oracle: The bug in the QueryTransformer that led to incorrect query 
  generation has been fixed.
- SQL Server: Loading field comments for objects from non-default schemas 
  and databases has been fixed.
+ PostgreSQL: Support for the WINDOW, FILTER clauses has been added.
+ SQLite: Support for the WINDOW and FILTER clauses and analytic expressions
  has been added.
= SQLite, Teradata: Support for the REPLACE function has been fixed.
= SAP Hana: Support for TOP and PLACEHOLDER clauses, NVARCHAR builtin type,
  CURRENT_UTC* constants have been added.
+ SAP Hana: Metadata filters are applied now to metadata fetching queries.
- SAP Hana: Working with table functions has been fixed.

January 13, 2020

Active Query Builder ActiveX Edition v.1.30.2

- The unhandled exception on component destruction has been eliminated.
- Universal SQL syntax: The bug with TIMESTAMPADD and TIMESTAMPDIFF functions
  is fixed.

Product Summary

 Active Query Builder WinForms .NET Edition:

 Active Query Builder WPF .NET Edition:

 Active Query Builder ASP.NET Edition:

 Active Query Builder Java Edition:

 Active Query Builder ActiveX Edition:

 Active Query Builder VCL Edition:



We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks