Active Query Builder History v.1.26.4
+ Polish translation is added. + Oracle: Calculation of SQL expression data types is made. - Better "IN" lists and date literal recognition in the select list is made. - MS SQL Server: Date parts are added to the list of valid identifiers. - ODBC "fn" call is fixed.
Active Query Builder History v.2.10.2
- The problem receiving 404 error for the 'ping' handler action is fixed. + Support for resizable layout is added. Read this article for details.
Active Query Builder History v.2.10.1
- HTML extension of ObjectTreeView for Razor view engine with support for Visual Studio 2013 is added.
Active Query Builder History v.2.10.0
+ The new metadata browsing control displaying database schema in a tree- like form is made instead of the old metadata list with drop-downs and pagination. It is compatible with all supported browsers and is used in all samples by default, but you still can use the old one. ! To change the old list control to new tree in your projects, just replace the AQB:ObjectTree ASP.NET control with the AQB:ObjectTreeView control. + Tooltip with full object name and description is now displayed in the Database Schema Tree. - Datasources in Design Area now keep their positions after toggling the component's visibility + The new JavaScript method QB.Web.Application.resetLayout() is added to restore the component's layout if it was created invisible on the page. + The new property Grid.DisableColumnsAutofixInIE10 is added. It should be used in case of modified CSS files if the Query Columns Grid is displayed incorrectly in IE 10.
Active Query Builder History v.1.26.3
+ ODBC literals and function calls syntax is supported now in all SQL syntaxes. - MS SQL Server: YEAR, MONTH and DAY can be used as valid identifiers now, the YEAR builtin function is fixed. - MS SQL Server: Support for DateAdd function is fixed. - Oracle: support ListAgg and XmlAgg in analytic expressions - Oracle: add CYCLE to valid identifiers list = Advantage DB: Support for Position function is added. + PostgreSQL: Support for UESCAPE in unicode string literals is made. = Condition type column for rows with empty criteria is set now to "for values" in the query columns grid. - A lot of minor optimizations, improvements and bug fixes are made.
Active Query Builder History v.1.26.3
+ ODBC literals and function calls syntax is supported now in all SQL syntaxes. - MS SQL Server: YEAR, MONTH and DAY can be used as valid identifiers now, the YEAR builtin function is fixed. - MS SQL Server: Support for DateAdd function is fixed. - Oracle: support ListAgg and XmlAgg in analytic expressions - Oracle: add CYCLE to valid identifiers list = Advantage DB: Support for Position function is added. + PostgreSQL: Support for UESCAPE in unicode string literals is made. + The new TacDatasourceObject.ObjectName property is added. = Condition type column for rows with empty criteria is set now to "for values" in the query columns grid. - A lot of minor optimizations, improvements and bug fixes are made.
Active Query Builder History v.2.10.4.750
- The bug that caused crash on right-clicking on the link when BehaviorOptions.LinkManipulations is set to LinkManipulations.Deny is fixed.
Active Query Builder History v.2.9.16
= The core component is updated.
Active Query Builder History v.2.9.15
- Fixes in the datasource z-index reordering and field drops are made. - Mnior changes in JS API are made.
Active Query Builder History v.2.9.13
- Test dialog was shown along with the firing of the GridBeforeCustomEditCell event. Fixed now. - The Custom Expression Editor sample is updated.
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!