Downloads

Active Query Builder ActiveX Edition History

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.

August 25, 2011

Active Query Builder ActiveX Edition v.1.17.6

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
- Adding objects with same AltName from the database objects tree is fixed.

August 23, 2011

Active Query Builder ActiveX Edition v.1.17.5

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
- MySQL: Reversed displaying of foreign key relationships is fixed.
- Exception is not raised now if the OleInitialize call is failed. 
  It's necessary for OLE drag'n'drop functionality.
- PostgreSQL: Parsing of SUBSTRING function and ARRAY literals is made.

August 11, 2011

Active Query Builder ActiveX Edition v.1.17.3

- Minor bugfixes are made.

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

Testimonials

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