Downloads

Active Query Builder ActiveX Edition History

September 19, 2023

Active Query Builder ActiveX Edition v.1.34.0

- Redshift: Metadata extraction is fixed.

August 17, 2023

Active Query Builder ActiveX Edition v.1.33.2

+ Support for Snowflake SQL syntax is made. (xsSnowflake = 150)
+ Support for Firebird v.4 SQL is made. (xsFirebird4 = 83)
= MySQL: Support for IS TRUE and IS FALSE clauses is improved.
- PostgreSQL: The ambiguity on parsing TIMESTAMP type name is eliminated.
- SQL Server: Parsing of the ZONE keyword as an identifier is fixed.
- The crash if quotation symbol is not defined by the syntax is eliminated.

July 14, 2023

Active Query Builder ActiveX Edition v.1.33.1

= PostgreSQL: Partitioned tables are fetched correctly now on schema load.
- PostgreSQL: Parsing of the AT TIME ZONE operator is fixed.
= MySQL: Support for Group_Concat function is added.
= MySQL: Support for IS TRUE and IS FALSE operators is added.
- Oracle: Ambiguities on parsing TIMESTAMP and DISTINCT clauses are eliminated.
- SAP Hana: The bug with STRING_AGG function with ORDER BY clause is fixed.
- MS SQL Server: Parsing of the AT identifier is fixed.

April 11, 2023

Active Query Builder ActiveX Edition v.1.33.0

+ SQL parsing preformance improvements and optimizations are made.

March 27, 2023

Active Query Builder ActiveX Edition v.1.32.5

= MS SQL Server: Object names are used as default aliased for unaliased objects.
- The crash if no fields were loaded when printing "table.*" is fixed.
- The crash on wrapping a query into a subquery for some complex queries is fixed.
- IBM DB2: The bug in the fields loading query for DB2 for AS/400 is fixed.
- PostgreSQL: Parsing of dollar-quoted string literals is fixed.

March 06, 2023

Active Query Builder ActiveX Edition v.1.32.4

= MS SQL Server: Alias is made required for table-valued functions to distinct
  them from tables with hints.
= Oracle: The objects are now loaded in alphabetic order.

February 06, 2023

Active Query Builder ActiveX Edition v.1.32.2

- MS SQL Server: The ambiguity on parsing a JOIN without join type is fixed.
- The bug with the incorrect fix-up for column names in sub-queries ORDER BY
  clause is fixed.

January 19, 2023

Active Query Builder ActiveX Edition v.1.32.1

+ PostgreSQL: The API to add new aggregate functions is made as follows.
    var rootItems = queryBuilder1.MetadataContainer.Items;
    var agg = new MetadataAggregate(rootItems) { Name = "custom_agg" };
    rootItems.Add(agg);
- MySQL: Hanging on parsing queries with GROUP_CONCAT functions is fixed.
- Crash on using the "Wrap Into Derived Table" feature for some queries is fixed.
- Crash on drawing the datasource selection frame in rare circumstances is fixed.

December 30, 2022

Active Query Builder ActiveX Edition v.1.32.0

+ Now it's possible to select multiple datasources in the Design Pane in 
  different ways:
  - select all datasources in a rectangular area with the mouse, 
  - select individual datasources while holding the Ctrl key,
  - select all the intermediate datasources between the given two ones
    (by joins) holding the Shift key.
+ The new "Wrap into derived table" action is added to the datasource 
  context menu to pack one or several datasources in a new derived table 
  preserving the joins and conditions in the current subquery. 

December 02, 2022

Active Query Builder ActiveX Edition v.1.31.14

= SQL Server: Alias is made required for table-valued functions to distinct 
  them from tables with hints.
- Oracle: Support for VALIDATE_CONVERSION built-in function is corrected.
- Using correct field name in ORDER BY if query has set operators (UNION, etc.)
- SAP Hana: Support for CHAR built-in function is fixed.
= Minimal control size is decreased.