Downloads

Active Query Builder 3 Core Edition History

January 27, 2017

Active Query Builder 3 Core Edition v.3.2.2.1035

+ IBM DB2: The ListAgg function is supported now.
+ Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields
  collections now include invalid objects and fields being used in the
  query. They differ from valid objects by the absence of MetadataObject
  (for objects) and MetadataField (for fields) references.
- MS SQL Server: DATEPART parser ambiguity has been fixed.

January 24, 2017

Active Query Builder 3 Core Edition v.3.2.2.1034

+ The new SQLite metadata provider has been added.
+ PostgreSQL: Support of materialized view, TOAST tables and foreign tables 
  has been made. 
+ Oracle: Support of the "AT TIME ZONE" clause has been added.
+ Firebird: Column name definition after alias in the FROM clause is
  supported now.
- The bug with loading of Query Transformer commands has been fixed.
- MySQL: Parsing of DATE, TIME, and DATETIME types as keywords has been
  fixed.

December 22, 2016

Active Query Builder 3 Core Edition v.3.2.1.1033

= MS SQL Server: Custom aggregates aren't loaded now from linked servers.
- MySQL: Proper fix up of string aliases has been made to avoid control 
  hang on some queries.

December 09, 2016

Active Query Builder 3 Core Edition v.3.2.1.1032

= PostgreSQL Metadata Provider: Reference to Npgsql has been updated.
- Displaying of Varchar(Max) and Varbinary(Max) data types in the datasource
  fields list has been fixed.
- MS SQL Server: List of valid identifiers has been updated.
- SQLite: Support for the string concatenation operator ("||") is fixed.

November 25, 2016

Active Query Builder 3 Core Edition v.3.2.1.1031

- Access: parsing Excel sheet names with dollar sign is fixed

October 26, 2016

Active Query Builder 3 Core Edition v.3.2.0.1029

+ Query Transformer is now capable of renaming output query columns.
+ The new QueryTransformer.RenameDuplicatedColumns property prescribes 
  to explicitly specify all the columns in the query SELECT list by
  expanding the asterisk items, then find and rename the unnamed and 
  duplicated column names (default = false).
+ The new QueryTransformer.AlwaysExpandColumnsInQuery instructs to perform
  asterisk expansion in the query SELECT list even if it's not needed for
  the specified query transformations (default = false).
! The OutputColumn.Name property has been renamed to OriginalName.
! The QueryTransformer.FindColumn method has been replaced with the 
  FindColumnByOriginalName and FindColumnByResultName methods.
+ The new OutputColumn.PreassignedName allows specifying the needed name 
  for a query output column.
+ The new OutputColumn.ResultName gets the result query columns name, which
  turned out as a result of automatic columns renaming routine and manual 
  appliance of the new name specified via the PreassignedName property.
= Batch query column items processing on grouping on/off has been made.
- QueryTransformer: The bug with incorrect ORDER BY generation if column
  alias is the same as field name has been fixed.
= QueryTransformer: The new SQLGenerationOptions property has been added,
  the SQLBuilder property has been removed.
= The InvalidOperationException is thrown now if both MetadataName and
  MetadataObject properties of the MetadataItem object are specified.
+ PostgreSQL: Support of custom aggregate functions has been made.
- MS SQL Server: CHAR and NCHAR, ROW and ROWS are added to the list of 
  valid identifiers.
- Firebird: The simple form of the TRIM function is supported now.
- Oracle: Special form of the TRIM function is supported now.
= Demo projects are updated and fixed.

September 07, 2016

Active Query Builder 3 Core Edition v.3.1.1.1028

- SubQuery object does not store precalculated list of inner subqueries, 
  but calcs it on demand.
- PostgreSQL: Date/time parts are added to the list of valid identifiers.
- PostgreSQL: Parsing of set operators is fixed.

August 24, 2016

Active Query Builder 3 Core Edition v.3.1.1.1026

- The bug with aggregate functions with an asterisk parameter ("*") is fixed.
- Other minor bugs are fixed.

August 17, 2016

Active Query Builder 3 Core Edition v.3.1.1.1025

- Minor changes are made.

August 08, 2016

Active Query Builder 3 Core Edition v.3.1.1.1024

- Minor changes are made.