Active Query Builder ActiveX Edition History

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
  fails. 
- 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
  fixed.

December 22, 2016

Active Query Builder ActiveX Edition v.1.26.33

= Debug version improvements have been made.
- The bug with the newly introduced PartialMetadataLoading property is fixed.
- DB2: Parsing of the CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP
  constants has been fixed.

December 15, 2016

Active Query Builder ActiveX Edition v.1.26.32

- The bug with the newly introduced PartialMetadataLoading property is fixed.
- MySQL: Proper fix up of string aliases has been made to avoid control 
  hang on some queries.

December 12, 2016

Active Query Builder ActiveX Edition v.1.26.31

- Loading metadata from XML has been fixed.

December 08, 2016

Active Query Builder ActiveX Edition v.1.26.30

+ The new IActiveQueryBuilderX.PartialMetadataLoading property has been
  added. Setting it to True prescribes the component to load metadata only
  for objects that were used in the query on assigning it to the SQL
  property. 
+ Mouse wheel works now in pick up lists of the Query Columns Grid.
+ The MetadataContainer.LoadFromXML method is significantly speeded up.
- Firebird: Support of aliases in the ORDER BY clause only for the version
  2.0 and higher.
- MS SQL Server: List of valid identifiers list has been updated.
- Single-line comments are recognized properly now.

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:

Tweets