Active Query Builder History v.1.13.0.0
+ Embarcadero RAD Studio 2010 is supported now. + Firebird 2.5 support is added. + Support of QuantumTreeList 5 is added, QuantumTreeList 4 is dropped (for DevExpress v.45 and higher) + The new property InnerKeywordInLinks is added to TacSQLBuilder and TacQueryBuilder components to suppress the "INNER" keyword in joins. - InterBase/Firebird: Fixed identifiers validity checks. - Sybase ASE support is fixed. - Parsing of highly parenthesized WHERE joins is fixed. - Right quotation in "Alias" column is made. - Right interpretation on writing the "='" and "'" strings in condition cell. - MS SQL: NULLIF function support is fixed. - PostgreSQL: SIMILAR TO operator support is fixed. - PostgreSQL: Escaped and unicode string literals support - MS SQL: Default database name querying under RemObjects DataAbstract is fixed. - Showing of the Query Properties dialog is fixed with Auto Syntax Provider. + RemObjects DataAbstract integration is updated. - Support of ElevateDB2 is fixed.
Active Query Builder History v.1.13.0.0
+ Firebird 2.5 support is added. - InterBase/Firebird: Fixed identifiers validity checks. - Sybase ASE support is fixed. - Parsing of highly parenthesized WHERE joins is fixed. - Right quotation in "Alias" column is made. - Right interpretation on writing the "='" and "'" strings in condition cell. - MS SQL: NULLIF function support is fixed. - PostgreSQL: SIMILAR TO operator support is fixed. - PostgreSQL: Escaped and unicode string literals support - Showing of the Query Properties dialog is fixed with Auto Syntax Provider.
Active Query Builder History v.1.9.6.184
+ Installation package now contains source code of metadata providers those depend on third-party ADO.NET providers. If you need to use some specific ADO.NET library version, you can rebuild a metadata provider with new references without our assistance.
Active Query Builder History v.1.9.4.181
+ Support for DevExpress 2009.1 controls is added (beta version). To use DevExpress controls, you should add a reference to the ActiveQueryBuilder.DevExpressControlFactory.dll file to your project or you may simply put the .dll near by your executable file. In the Main() function of your application, before any form creation, set up the DevExpress usage and turn on QueryBuilder's static property "UseDevExpressControls": DevExpress.Skins.SkinManager.EnableFormSkins(); QueryBuilder.UseDevExpressControls = true; Your project also must refer to DevExpress.Data.*, DevExpress.Utils.*, DevExpress.XtraEditors.*, DevExpress.XtraGrid.* and DevExpress.XtraTreeList.* assemblies. Beta version is available upon a request. = TableChecksCountInCaption property is renamed to CheckedFieldsCountInCaption.
Active Query Builder History v.1.12.6.0
+ SQL 2003 syntax provider: minor updates are made. + The new property is added to allow visual setting of NULLS FIRST/NULLS LAST options: TacQueryBuilder.SelectListOptions.ShowNullOrderingInSortTypeColumn. - Fixed: "NOT IN", "NOT LIKE" and "NOT BETWEEN" clauses were being split apart. - PostgreSQL: Bug in parsing of INTO clause is fixed. + Oracle: &-style parameters support is added.
Active Query Builder History v.1.12.6.0
+ SQL 2003 syntax: minor updates are made. + The new property is added to allow setting of NULLS FIRST/NULLS LAST options: IActiveQueryBuilderX.SelectListOptions.ShowNullOrderingInSortTypeColumn. - Fixed problem with 'as alias' truncation in OnBeforeAddDatasource event. - Fixed: "NOT IN", "NOT LIKE" and "NOT BETWEEN" clauses were being split apart. - PostgreSQL: Bug in parsing of INTO clause is fixed. + Oracle: &-style parameters support is added.
Active Query Builder History v.1.9.3.180
- Fixed: "NOT IN", "NOT LIKE" and "NOT BETWEEN" clauses were being split apart.
Active Query Builder History v.1.1.0.1013
- Fixed: "NOT IN", "NOT LIKE" and "NOT BETWEEN" clauses were being split apart.
Active Query Builder History v.1.1.0.1012
- PostgreSQL: bug in parsing of INTO clause is fixed.
Active Query Builder History v.1.9.3.179
- PostgreSQL: Bug in parsing of INTO clause is fixed.
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!