Downloads

Active Query Builder ActiveX Edition History

July 24, 2015

Active Query Builder ActiveX Edition v.1.25.4

- Automatic addition of condition columns in the Query Columns Grid is fixed.

July 10, 2015

Active Query Builder ActiveX Edition v.1.25.3

- Using RTL flags even for SQL columns in the Query Columns Grid is made.

July 09, 2015

Active Query Builder ActiveX Edition v.1.25.2

= Teradata: Data type names are displayed correctly now.
= MySQL: Support of "SUBSTRING(a FROM b TO c) is added.
- Advantage: Editing of TOP clause in the Query Properties dialog is fixed.
= Minor improvements for RTL script languages are made.
= Query Transformer: minor bug fixes are made.

June 11, 2015

Active Query Builder ActiveX Edition v.1.25.1

+ Localization to Farsi language is added.
+ Query Transformer state serialization to XML string is made. 
  Use the IacQueryTransformer.StateXML property to save and load state.
= Grouping checkbox is hidden now for query columns with constant SQL
  expressions.
= Query Column List control now obeys RTL flag for captions, but ignores 
  it for SQL expressions.
= Algorithm trying to preserve conditions order in WHERE and HAVING clauses
  is implemented.
+ AdvantageDB: Support for the CONTAINS full-text search function is made.
+ PostgreSQL: Support for materialized views is made.
= Intofmix: Metadata objects loading is made more reliably now.

May 19, 2015

Active Query Builder ActiveX Edition v.1.25.0

+ Support of RTL languages is improved.
+ Ability to select muptiple rows in the Query Columns Grid eases 
  re-ordering of query columns.
= The Aggregate column of the Query Columns Grid is moved closer to the 
  Grouping column.
= Now when query grouping is cancelled by unchecking the main Grouping 
  option, the ConditionType ("Criteria For" column) is set to ctWhere 
  ("For values") only for non-aggregated columns.
- QueryTransformer: Wrapping of queries with several unnamed columns is
  fixed.
= ANSI SQL/2003: Using the TABLE wrapper for stored procedures in FROM is 
  possible now.
+ AdvantageDB: Support for IIF builtin function is made.
- AdvantageDB: Parsing of the LEFT and RIGHT builtin functions is fixed.
- MySQL: Support for CHAR builtin function is made.
- DB2: Duplication of the TABLE wrapper for stored procedures is fixed.
= Informix: The system "INFORMIX" schema now treated as non-system if no
  other schemas are found.

March 24, 2015

Active Query Builder ActiveX Edition v.1.24.12

- PostgreSQL: LIKE (ANY|SOME|ALL) is supported now.
- Query Transformer: Construction of NOT BETWEEN condition is fixed.
= Column aliases entered in the Query column list are always quoted now 
  to preserve the case. 
+ Query columns list height and columns width are preserved now on query
  reloading and manual SQL text changes.

March 10, 2015

Active Query Builder ActiveX Edition v.1.24.11

= Focus is not moved on mouse hover over datasources on the Design pane
  if the component is not focused.
- Incorrect loading of ORDER BY is fixed.

February 06, 2015

Active Query Builder ActiveX Edition v.1.24.10

- Minor parsing speed improvements are made.

January 21, 2015

Active Query Builder ActiveX Edition v.1.24.9

= Scanner performance optimizations are made.

December 19, 2014

Active Query Builder ActiveX Edition v.1.24.8

= DB2: The query to load default schema is corrected for older mainframes.
= DB2: Metadata objects loading is improved for older mainframes: fallback
  to QSYS2.SYSTABLES is made.
- Loading join conditions with references to objects from parent query 
  is fixed.
- Loading FROM clause enclosed with parenthesis is fixed.
- Memory leak is fixed.