Active Query Builder ActiveX Edition History

October 03, 2013

Active Query Builder ActiveX Edition v.1.22.1

+ MS SQL Server: CLR method calls support is made.
= The linked objects button is placed on the panel now.
= French translation is updated.
- Other bug fixes are made.

October 01, 2013

Active Query Builder ActiveX Edition v.1.22

+ The new button is now shown at the right of the focused datasource on Design
  pane to allow easy adding of linked objects to the query. 
+ The new datasource context menu item is added for the same purpose.
- MS Access: Parsing of the ASC builtin function is fixed.

September 13, 2013

Active Query Builder ActiveX Edition v.1.21.8

= Layout: Horizontal interval between datasources is decreased to 40 px.

September 12, 2013

Active Query Builder ActiveX Edition v.1.21.7

+ Query layout is now preserved after parsing of the modified query.
+ Algorithm of automatic objects placement on the diagram pane is improved.
- Small fixes for MSStyleGrouping mode are made.

August 29, 2013

Active Query Builder ActiveX Edition v.1.21.6

= Alternate Names now obey server identifier case sensitivity rules.
- The bug with incorrect bracketing of inner OR conditions is fixed.
= MS Access: Builtin functions siffixed with the dollar sign are supported now.
- Oracle: Usage of the "TIMESTAMP" keyword as column name is possible now.
= MS SQL Server: Table hints are updated according to the SQL Server 2012 

July 04, 2013

Active Query Builder ActiveX Edition v.1.21.5

- SQLite: Fields list loading for tables with BLOB columns through ODBC is fixed.

June 27, 2013

Active Query Builder ActiveX Edition v.1.21.4

- Recently introduced bug that led to the emptiness of field lists is fixed.

June 19, 2013

Active Query Builder ActiveX Edition v.1.21.2

- Deadlock on OCX unload in Clarion is fixed.

June 18, 2013

Active Query Builder ActiveX Edition v.1.21.1

= PostgreSQL: LEFT and RIGHT builtin functions are supported now.

May 30, 2013

Active Query Builder ActiveX Edition v.1.21.0

+ The new IQueryTransformer interface is added. It is intended to easily
  modify SQL query sorting, filtration and aggregation programmatically. 
  You can get it's instance via the IActiveQueryBuilderX.QueryTransformer 
+ The new properties are added to the ExpressionBuilderParams class that is 
  passed to the OnCustomExpressionEditor event handler:
  ExpressionKind (ekExpression, ekWhere or ekHaving), RelatedExpression,
  RelatedField, RelatedObject.
= Internal change: Binding of column names is not performed now if fieldless
  datasources are in the scope.
= MySQL: The BINARY prefix operator is supported 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:



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