Downloads

Active Query Builder ActiveX Edition History

December 13, 2011

Active Query Builder ActiveX Edition v.1.18.2

+ CTE sub-queries are filtered properly now on setting such filtration with the
  FilterTabsByActiveQueryPart property.

December 02, 2011

Active Query Builder ActiveX Edition v.1.18.1

+ The new property IActiveQueryBuilderX.FilterSqlByActiveQueryPart is added. 
  It allows you to generate the SQL query text not for the whole query, but
  for active part of the query only. Possible values are the following:
  qpQuery=0 (default): generate SQL text for the whole query;
  qpSubQuery=1: generate text for the currently active sub-query tab;
  qpUnionSubQuery=2: generate text for the currently active union sub-query.
  The generated SQL text of active query part can be read from or written to 
  the IActiveQueryBuilderX.ActiveQueryPartSQL property. 
  The OnActiveQueryPartSQLChanged event is fired when ActiveQueryPartSQL 
  is changed.
+ The new IActiveQueryBuilderX.FilterTabsByActiveQueryPart property is added. 
  It allows to hide the tabs that do not belong to the currently active query
  part. Possible values are the same as for the FilterSqlByActiveQueryPart.
- MySQL: Parsing of sub-queries in criteria cells is fixed.
- Loading of outer joins in WHERE is fixed.
- The link popup menu does not allow to create FULL OUTER joins for links in
  WHERE clause now.

December 01, 2011

Active Query Builder ActiveX Edition v.1.18.0

= Russian translation is updated.

November 21, 2011

Active Query Builder ActiveX Edition v.1.17.13

- Fixed: Aliases in ORDER BY are used for queries with unions only.

November 07, 2011

Active Query Builder ActiveX Edition v.1.17.12

- Small memory leak is fixed.
- "Invalid pointer operation" error introduced in version 1.17.9 is fixed.

November 01, 2011

Active Query Builder ActiveX Edition v.1.17.11

+ Support of ORDER BY in queries with unions is improved.
+ Yet another bunch of speed optimizations is made.

October 28, 2011

Active Query Builder ActiveX Edition v.1.17.10

+ MS SQL Server: Support of variables as query datasources is made. 
  (select * from @variable)
+ MySQL: Parsing of nested functions is speeded up.
- Fixed bug with qualified names comparison introduced in the previous version.

October 26, 2011

Active Query Builder ActiveX Edition v.1.17.9

+ Parsing and working with large queries is speeded up.
+ PostgreSQL: list of builtin functions is added.

October 11, 2011

Active Query Builder ActiveX Edition v.1.17.8

= Ordering for the query column is removed now when grouping become unchecked;
  grouping is checked when ordering added.
= Grouping is turned on for the query column when user indicates it's conditions
  to be appled for groups (i.e. to the HAVING clause).
= MS SQL Server: "FOR XML" clause is updated to support Ms Sql Server "Denali".
= MySQL: COALESCE, GREATEST, LEAST and INTERVAL added to the list of builtin
  functions.
= PostgreSQL: Function "substring('test',1,2)" is converted to "substring('test'
  from 1 for 2)" on parsing the query.
= Firebird: INT type alias is supported.
- AV when editing the query columns list in rare cases is fixed.
- Assignment of unnecessary aliases for expressions in rare cases is fixed.

September 02, 2011

Active Query Builder ActiveX Edition v.1.17.7

= QueryStatistics.OutputColumns.ExpressionAlias is now unquoted.
= Conditions aren't turned to HAVING automatically for grouped query columns.
- Oracle: TRANSLATE function is fixed.