Active Query Builder History v.3.6.2.1161
+ The new event MetadataContainer.MetadataLoadingError is added to take additional actions on error executing queries to retrieve database schema. + The new event MetadataContainer.MetadataLoadingErrorNotification event is added to display notifications about errors executing metadata retrieval queries. One can suppress displaying error notifications to users by handling the MetadataLoadingError event and setting its Abort parameter to True to suppress firing of the MetadataLoadingErrorNotification event. + Logging of the metadata retrieval queries is fixed and improved. - Localization of messages in .NET Core assemblies has been fixed.
Active Query Builder History v.3.6.2.1161
+ The new event MetadataContainer.MetadataLoadingError is added to take additional actions on error executing queries to retrieve database schema. + The new event MetadataContainer.MetadataLoadingErrorNotification event is added to display notifications about errors executing metadata retrieval queries. One can suppress displaying error notifications to users by handling the MetadataLoadingError event and setting its Abort parameter to True to suppress firing of the MetadataLoadingErrorNotification event. + Logging of the metadata retrieval queries is fixed and improved. - SQL Text Editor: The bug in the Find and Replace dialog on firing search with an empty pattern has been fixed. - Localization of messages in .NET Core assemblies has been fixed.
Active Query Builder History v.3.6.2.1161
+ The new event MetadataContainer.MetadataLoadingError is added to take additional actions on error executing queries to retrieve database schema. + The new event MetadataContainer.MetadataLoadingErrorNotification event is added to display notifications about errors executing metadata retrieval queries. One can suppress displaying error notifications to users by handling the MetadataLoadingError event and setting its Abort parameter to True to suppress firing of the MetadataLoadingErrorNotification event. + Logging of the metadata retrieval queries is fixed and improved. - SQL Text Editor: The bug in the Find and Replace dialog on firing search with an empty pattern has been fixed. - Localization of messages in .NET Core assemblies has been fixed.
Active Query Builder History v.3.6.2.402
+ The user can switch now to sub-queries in WHERE and HAVING parts of the query using a button next to a corresponding field in the datasource field list. + Notifications about metadata loading errors are displayed now in the Notification bar. - Localization of messages in .NET Core assemblies has been fixed.
Active Query Builder History v.3.6.1.1160
+ Query Navigation Bar: The new way to display the path to subqueries is made. Now when you switch to a subquery, a breadcrumb displaying the path from the main query to the current subquery is drawn; subqueries that don't belong to the current subquery are hidden. This mode is turned on by default. You can switch it off by setting the QueryBuilder.QueryNavBarOptions. ShowPathToCurrentSubQuery property to False. + The Metadata Container Editor executable is included in the Professional and Trial installation packages. = It's now possible to zoom in/out objects on the Design pane using the Ctrl+Plus/Minus and Ctrl+MouseWheel shortcuts. = Existing object is linked when creating a new join rather than adding a new object, but only if it's not yet linked in another way. = Predefined SQL expressions are indicated with their names instead of SQL expression texts in the field context menu. = It is now easy to add more than one folder to the root. = "Object" is not displayed as a field data type anymore when it's not possible to determine it. + Syntax providers: The new property QueryToLoadFieldsTemplate allows for customizing the query to load the list of fields for an object. + Metadata providers: The new property CommandTimeout allows for changing the timeout for metadata loading queries. = The default value of MetadataStructureOptions.GroupByTypes property is changed to True. = Oracle: Objects of excluded types (tables, views, procedures, synonyms) aren't loaded to the MetadataContainer anymore. - Oracle: Synonyms for objects that are not loaded to the metadata container aren't hidden now to speed-up a load of synonyms. = Consolidated Metadata Container demo: The "Show DataSources stats" button is added.
Active Query Builder History v.3.6.1.1160
+ Query Navigation Bar: The new way to display the path to subqueries is made. Now when you switch to a subquery, a breadcrumb displaying the path from the main query to the current subquery is drawn; subqueries that don't belong to the current subquery are hidden. This mode is turned on by default. You can switch it off by setting the QueryBuilder.QueryNavBarOptions. ShowPathToCurrentSubQuery property to False. + The Metadata Container Editor executable is included in the Professional and Trial installation packages. = Existing object is linked when creating a new join rather than adding a new object, but only if it's not yet linked in another way. = Predefined SQL expressions are indicated with their names instead of SQL expression texts in the field context menu. = It is now easy to add more than one folder to the root. = "Object" is not displayed as a field data type anymore when it's not possible to determine it. + Syntax providers: The new property QueryToLoadFieldsTemplate allows for customizing the query to load the list of fields for an object. + Metadata providers: The new property CommandTimeout allows for changing the timeout for metadata loading queries. - Scaling in the WinForms and DevExpress controls UI is fixed. = The default value of MetadataStructureOptions.GroupByTypes property is changed to True. = Oracle: Objects of excluded types (tables, views, procedures, synonyms) aren't loaded to the MetadataContainer anymore. - Oracle: Synonyms for objects that are not loaded to the metadata container aren't hidden now to speed-up a load of synonyms. = Consolidated Metadata Container demo: The "Show DataSources stats" button is added.
Active Query Builder History v.3.6.1.1160
+ The Metadata Container Editor executable is included in the Professional and Trial installation packages. + Syntax providers: The new property QueryToLoadFieldsTemplate allows for customizing the query to load the list of fields for an object. + Metadata providers: The new property CommandTimeout allows for changing the timeout for metadata loading queries. = Oracle: Objects of excluded types (tables, views, procedures, synonyms) aren't loaded to the MetadataContainer anymore. - Oracle: Synonyms for objects that are not loaded to the metadata container aren't hidden now to speed-up a load of synonyms. = Consolidated Metadata Container demo: The "Show DataSources stats" button is added.
Active Query Builder History v.3.6.1.401
+ The component is compatible with ASP.NET Core 3.1. + The new property QueryBuilder.DatabaseSchemaViewOptions.CustomSorter is added. = Field context menus are cleaned up. + It's possible now to prevent the creation of links and datasources using the Abort parameter of DataSourceAdding and LinkAdding events on the client. - Working without the Design Pane in the client-side rendering mode is fixed. - Filling the Expression cells drop-down list if the Canvas doesn't exist is fixed. - The issue with maintaining the session using cookies in multi-domain configurations is fixed. - The logging of syntax provider events is fixed.
Active Query Builder History v.3.6.0.400
+ The indication of sorting, aggregation, and conditions for a column in the object field list on Design Pane has been made. + The new way to define sorting, grouping, aggregations, and sorting via the context menu of the datasource field list has been introduced. It also helps to switch to the existing condition in the Query Columns grid. + It's possible now to define a set of ready-to-use conditions for specific fields and data types for instant applying via the datasource field list context menu. + New SPA demos for React, Angular, and Vue.js have been made. + Hebrew and Dutch localizations have been added; other localizations are updated. = Query Transformer: The ability to add grouping (GROUP BY section) to the initial query has been made. + The ability to consolidate metadata from different connections to use in one SQL query has been added.
Active Query Builder History v.3.6.0.1159
+ The indication of sorting, aggregation, and conditions for a column in the object field list on Design Pane has been made. + The new way to define sorting, grouping, aggregations, and sorting via the context menu of the datasource field list has been introduced. It also helps to switch to the existing condition in the Query Columns grid. + It's possible now to define a set of ready-to-use conditions for specific fields and data types for instant applying via the datasource field list context menu. + The user can switch now to sub-queries in WHERE and HAVING parts of the query using a button next to a corresponding field in the datasource field list. + Support for the Right-to-left oriented layout has been made. + Hebrew and Dutch localizations have been added; other localizations are updated. = The programmer now has full control over the context menus.
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!