Downloads  »  Active Query Builder VCL Edition History

March 13, 2017

Active Query Builder VCL Edition v.1.26.34

Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.26.34.

= Automatic links creation has been improved: links are created only from
  Parent to Child table or vice vera, but not both at the same time.
= The StatisticOutputColumn.ColumnNameInQuery is now quoted if need.
= The StatisticOutputColumn.MetadataField calculation has been improved.
+ The new properties TrimQuotes and TrimSpaces have been added to the
  BaseMetadataProvider class.
= Firing of the ActiveSubQueryChanging/Changed event is enforced on the
  query clearing.
- DevExpress UI: Click on the checkbox in the datasource field list has been
  fixed.
+ 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.
+ IBM DB2: The ListAgg function is supported now.
+ IBM DB2: The QSYS2 tables are used now for fields loading if this scheme
  exists. Several minor bugs have been fixed.
+ SQLite: Support for the IS operator ("expr IS expr") has been added.
- SQLite: The bug with not loading fields for a table being added second to
  the query has been fixed.
- MS SQL Server: loading objects from non-default schemas for non-default
  databases is fixed
- MS SQL Server: The DATEADD parser unambiguity has been fixed.
- MySQL: Parsing of DATE, TIME and DATETIME types as keywords has been
  fixed.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder VCL Edition at the download page.

» Full Active Query Builder VCL Edition history