Active Query Builder ActiveX Edition History

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
= 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
= 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.

December 05, 2014

Active Query Builder ActiveX Edition v.1.24.7

+ SQLite: Support CTE at sub-queries level is added.
= Oracle: Oracle8i compatibility fixes are made.
= Comments parsing is fixed.

November 14, 2014

Active Query Builder ActiveX Edition v.1.24.6

+ Support for AdvantageDB SQL syntax is made. 
  Set the SQLSyntax property to xsAdvantage=130 to select this syntax.
- Minor bug fixes are made.

October 29, 2014

Active Query Builder ActiveX Edition v.1.24.5

- General SQL parsing bug is fixed.

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:



We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks