Active Query Builder 3 ASP.NET Edition v.3.0.4
= The new client events AQB.Web.onQueryBuilderReady and AQB.Web.onCriteriaBuilderReady are added to replace the onApplicationReady event. = The QueryBuilder.Logger and AqbHandler.Logger properties have been renamed to Log. = All configuration properties (getters) that must be defined through the configuration file have been moved from the SessionStore class to the appropriate handlers (BaseHandler, AqbHandler, ResourceHandler). = Lots of minor fixes and improvements in HTML code and demo projects have been made. = Direct references to third-party assemblies have been replaced with appropriate Nuget packages where it was possible. = Batch metadata loading is now more intelligent to avoid delays on getting the list of fields for the first requested table. - The bug with restoring layout for non-existing elements has been fixed. - Computation of primary and foreign keys field lists has been fixed. - The bug with deserializing complex metadata structure has been fixed. - The bug with grouping database objects in the tree by types has been fixed. - Several visual glitches have been addressed. - Server memory leaks have been eliminated.
Active Query Builder 3 ASP.NET Edition v.3.0.3
+ The ability to edit text of sub-queries separately from the entire query has been made. Read the Knowledge Base article at https://support.activequerybuilder.com/hc/en-us/articles/360000148009 and review the Edit Sub-Query Text Demo project. + The new SqlEditor.TargetQueryPart property has been added. It accepts the Query, SubQuery and UnionSubQuery values. + The new QueryBuilder.ActiveUnionSubQueryChanged event has been added. + The new activeSubQuerySQL and activeUnionSubQuerySQL properties have been added to the AQB.Web.QueryBuider object on the client. + The new addNewNamedSubQuery, addDerivedTable, addUnionSubQuery methods have been added to the AQB.Web.QueryBuilder object to make possible execute these commands from JavaScript. + The new AQB.Web.QueryBuilder.dispose method destroys the QueryBuilder object both on the server and client. - The bug with displaying field name instead of column alias has been fixed. - The bug with the design pane context menu has been fixed. - Localization of the Properties forms has been fixed. - Z-index for some HTML elements has been corrected. = Resource packing and caching has been made. + The new configuration property EnableResourceCaching has been added.
Active Query Builder 3 ASP.NET Edition v.3.0.2
= Splitters between controls are shown by default now. - Loading of reusable queries has been fixed.
Active Query Builder 3 ASP.NET Edition v.3.0.1
- Several HTML layout bugs have been fixed. - Inappropriate SQL queries in demo projects have been corrected. - Complex links are bound correctly to the middle of datasource caption now. = SubQuery.Caption property returns localized caption for the main query. = Default namespaces aren't shown in datasource captions now. - Metadata Structure: Grouping by types at the top level has been fixed. = Only the simple WHERE clause conditions like "field1 = field2" are loaded as links now. - Generation of offset in the LIMIT expression has been fixed.
Active Query Builder 3 ASP.NET Edition v.3.0.0
The first beta version is out.
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!