Active Query Builder History v.2.12.0
+ Ability to restore the component's state after session expiration without reloading the page has been made. = Ping action now detects session expiration. + Overlay to disable visual UI controls is made. The new functions are added to show/hide the overlay: QB.Web.Application.showOverlay(message), QB.Web.Application.hideOverlay(). + New functions are added to set and clear the filter for the Database Schema Tree: QB.Web.Application.TreeComponent.setFilter(filter), QB.Web.Application.TreeComponent.clearFilter(). - The bug with not displaying fields if object added twice to the canvas has been fixed. - The procedure parameters dialog was displayed incorrectly using the old database schema control. Fixed now. - The bug with incorrect displaying of objects in the old schema tree control in MVC projects is fixed. - A memory leak while using the control in "Multiple Queries Per Session" mode has been eliminated.
Active Query Builder History v.2.10.5.792
+ Aggregate and builtin functions list is cached now to speed up large query text generation. = MetadataItem: InvalidOperationException is thrown now if both MetadataName and MetadataItem property values are specified. = UnionSubQuery.AddDatasource*At method: if any of the drop coordinates is negative, drop position is calculated automatically. Note that this method treats given coordinates as absolute screen coordinates. - MS SQL Server: CHAR(n) parser ambiguity is fixed. - MS SQL Server: ROW and ROWS are added to the list of valid identifiers.
Active Query Builder History v.1.26.28
+ Query Transformer is now capable to rename output query columns. + The new TacQueryTransformer.RenameDuplicatedColumns property prescribes to explicitly specify all the columns in the query SELECT list by expanding the asterisk items, then find and rename the unnamend and duplicated column names (default = false). + The new TacQueryTransformer.AlwaysExpandColumnsInQuery instructs to perform asterisk expansion in the query SELECT list even if it's not needed for the specified query transformations (default = false). ! The TacOutputColumn.Name property has been renamed to OriginalName. + The new TacOutputColumn.PreassignedName allows specifying the needed name for a query output column. + The new TacOutputColumn.ResultName gets the result query columns name, which turned out as a result of automatic columns renaming routine and manual appliance of the new name specified via the PreassignedName property. - QueryTransformer: The bug with sorting by a column, which alias is equal to the field name, has been fixed. - The "Build Expression" popup menu item is now shown only when a handler is assigned to the OnCustomExpressionBuilder event. - MS SQL Server: CHAR(n) parser ambiguity has been fixed. - MS SQL Server: CHAR and NCHAR have been moved from the builtin functions to the list of valid identifiers. + PostgreSQL: Support for custom aggregate functions has been added. - PostgreSQL: Date/time parts have been added to the list of valid identifiers. = ElevateDB packages have been updated to comply with the latest version.
Active Query Builder History v.1.26.28
+ Query Transformer is now capable to rename output query columns. + The new property aqbxQueryTransformer.RenameDuplicatedColumns property prescribes to explicitly specify all the columns in the query SELECT list by expanding the asterisk items, then find and rename unnamend and duplicated column names (default = false). + The new aqbxQueryTransformer.AlwaysExpandColumnsInQuery instructs to perform asterisk expansion in the query SELECT list even if it's not needed for the specified query transformations (default = false). ! The aqbxOutputColumn.Name property is renamed to OriginalName. + The new aqbxOutputColumn.PreassignedName allows to specify the needed name for a query output column. + The new aqbxOutputColumn.ResultName gets the result query columns name which turned out as a result of automatic columns renaming routine and manual appliance of the new name specified via the PreassignedName property. - QueryTransformer: The bug with sorting by a column , which alias is equal to field name is fixed. - The "Build Expression" popup menu item is now shown only when a handler is assigned to the OnCustomExpressionBuilder event. - MS SQL Server: CHAR(n) parser ambiguity is fixed. - MS SQL Server: CHAR and NCHAR are moved from the builtin functions to the list of valid identifiers. + PostgreSQL: Support for custom aggregate functions is added. - PostgreSQL: Date/time parts are added to the list of valid identifiers.
Active Query Builder History v.2.10.5.790
+ PostgreSQL: Support for custom aggregate functions is added. - Query Transformer: The bug with incorrect generation of the ORDER BY clause if column alias is same as field name is fixed. - MS SQL Server: CHAR and NCHAR are added to the list of valid identifiers. - Query Structure Tree flickering on batch query items processing is eliminated. - The bug with getting empty nodes on copying Database Schema Tree to another control is fixed.
Active Query Builder History v.2.11.9
- The bug with inability to modify table alias is fixed.
Active Query Builder History v.2.11.8
+ PostgreSQL: Support for custom aggregate functions is added. - Query Transformer: The bug with incorrect generation of the ORDER BY clause if column alias is same as field name is fixed. - The bug with invalid generation of queries containing derived tables when the SQLGenerationOptions.QuoteAllIdentifiers property is set to true is fixed. - The bug with inability to uncheck a field in datasource field list is fixed.
Active Query Builder History v.3.1.1.1028
- SubQuery object does not store precalculated list of inner subqueries, but calcs it on demand. - PostgreSQL: Date/time parts are added to the list of valid identifiers. - PostgreSQL: Parsing of set operators is fixed.
Active Query Builder History v.3.1.1.1028
- SubQuery object does not store precalculated list of inner subqueries, but calcs it on demand. - PostgreSQL: Date/time parts are added to the list of valid identifiers. - PostgreSQL: Parsing of set operators is fixed.
Active Query Builder History v.2.10.5.788
- PostgreSQL: Date/time parts are added to the list of valid identifiers. - PostgreSQL: Parsing of set operators 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!