Active Query Builder ActiveX Edition History

August 18, 2017

Active Query Builder ActiveX Edition v.1.27.10

+ The new property ISelectListOptions.DropdownInExpressionColumn has been
  added. Turn it off to hide the drop-down list in the Expression column of
  the Query Columns Grid.

August 15, 2017

Active Query Builder ActiveX Edition v.1.27.9

- Localization fixes in Properties forms have been made.
- Correct column prefix is emitted for procedures and table-valued functions.
- Minor memory leaks have been eliminated.

August 02, 2017

Active Query Builder ActiveX Edition v.1.27.8

= Icons in the Union Navigation Bar and Query Columns List control are 
  correctly scaled now on High DPI monitors.
= ODBC: Metadata filters are now applied on loading objects from driver.

July 20, 2017

Active Query Builder ActiveX Edition v.1.27.3

- The bug with applying result column names for queries with asterisk items
  when fields aren't loaded yet has been fixed.
- Filtration by aggregated columns has been fixed.

June 24, 2017

Active Query Builder ActiveX Edition v.1.27.2

+ The Custom Expression Editor ellipsis button doesn't hide the combo box
  button in the inline editor of Expression column in the Query Columns
  Grid, but displayed next to it.
- The bug with incorrect loading of conditions joined with the topmost OR
  operator has been fixed.
- Access violation on pressing the TAB key in an empty Query Columns Grid
  control with an inactive editor has been fixed.
+ PostgreSQL, MySQL, SQLite, Netezza: Support for expressions in
  LIMIT/OFFSET clauses has been added.

June 09, 2017

Active Query Builder ActiveX Edition v.1.27.1

+ Conditions for the same left part joined using the OR operator are merged
  into a single cell now. 
+ The new WhereNewLineBefore and HavingNewLineBefore properties have
  been added to IActiveQueryBuilderX.SelectFormat group to add new lines
  before the specified types of operators. Possible values are the
  following: None, TopmostOr, TopmostLogical, AllLogical. 
- IBM DB2: The bug with appending LIMIT OFFSET by the Query Transformer
  has been fixed. 
- Oracle: A workaround for Microsoft ODBC driver bug has been made. Fields
  are loaded now using the non-parametrized query if the parametrized query
- The bug with loading of CTE referred in a reverse order has been fixed. 
- MS SQL Server: Fake ORDER BY is added correctly now if there is no
  ordering in the transformed query. 
- Oracle: Loading of fields for synonyms has been fixed.

April 29, 2017

Active Query Builder ActiveX Edition v.1.27.0

+ MySQL: Support of MATCH full-text search operator has been added. 
= DB2: The list of available databases is taken from the driver now.
  (OLE DB or ODBC). 
- DB2: The bug with selecting table owner instead of table schema for 
  schema name has been fixed.
- Access violation on removing active CTE has been eliminated. 

March 23, 2017

Active Query Builder ActiveX Edition v.1.26.36

- MetadataProvider.LoadFieldsForObjectFromDriver: The TrimQuotes flag is
  taken into account now.
- MetadataContainer.LoadMetadataByFilter: Access violation on calling without
  a connection while loading objects using events has been eliminated.

March 17, 2017

Active Query Builder ActiveX Edition v.1.26.35

+ SQLite: Right outer joins are converted to left now.
= SQLite: Non-qualified double-quoted identifiers are treated as strings now.
- MS SQL Server: Built-in @@-named variables are recognized now.
- Oracle: Date/time built-in constants are recognized properly now.

March 13, 2017

Active Query Builder ActiveX 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.
+ 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

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: