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.
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.
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.
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.
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.
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.
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.
Active Query Builder ActiveX Edition v.1.17.3
- Minor bugfixes are made.
Active Query Builder ActiveX Edition v.1.17.2
= MS SQL: Loading objects from linked servers is restored. = MySQL: Parsing of the ORDER BY clause is improved. - Mimer Sql: Reference type is not supported by MimerSql. Fixed now. - AV on creating link by identical field names is fixed.
Active Query Builder ActiveX Edition v.1.17.1
+ MS SQL Server: Table and query hints are supported; join hints are parsed fine now, but not preserved due to architecture limitations. - SQLite: Parsing of sub-queries in condition cells is fixed. - German translation: Wrong translation "Default"->"German" is reverted to "Default". = MySQL: UNSIGNED is treated as a valid data type now.
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!