Active Query Builder History v.3.6.5.1163
+ Metadata loading errors are displayed now via the notification bar. + The new property QueryBuilder.BehaviorOptions.AllowMessageTypes is added to determine the types of messages to be shown in the notification bar. + The new property QueryBuilder.DesignPaneOptions.DesignPaneOverviewMaxHeight is added to determine the maximum ratio (range from 0 to 1) of the overview pane height and overall Design Pane height. The actual width and height of the overview pane is now calculated according to new and DesignPaneOverviewWidth properties. = QuickBooks (QODBC): Support for the TOP clause is added, support for derived tables is turned off. = PostgreSQL: Backslash quotation for generic string literals has been removed. = Metadata serialization to XML: The "Loaded" flag for all types of objects is now set on for a namespace if child database objects of any type exist.
Active Query Builder History v.3.6.5.1163
= QuickBooks (QODBC): Support for TOP clause is added, support for derived tables is turned off. = PostgreSQL: Backslash quotation for generic string literals has been removed. = Metadata serialization to XML: The "Loaded" flag for all types of objects is now set on for a namespace if child database objects of any type exist.
Active Query Builder History v.2.10.19.830
= References to DevExpress WinForms controls are updated to v.20.1.3.
+ PostgreSQL: Support for the FILTER clause is added and the bug with the
PRECEDING clause is fixed.
= SQLite, Teradata, Generic: Support for the REPLACE function is added.
+ SQLite: Support for window functions, analytic expressions, and the FILTER
clause has been added.
- MySQL: Parsing of the MATCH full-text search expression is fixed.
- PostgreSQL: Support for WITH clause in subqueries has been added.
- MS SQL Server: Parsing of ordinal named parameters ("@0") has been
restored.
- Informix: Support for sub-queries has been fixed.
- Generic Syntax Provider: loads metadata from Oracle fine now.
Active Query Builder History v.3.6.4.404
- Minor aqb.client.js fixes are made.
Active Query Builder History v.3.6.3.403
+ All the server-side properties can be applied via the configuration file now. The new visual tool lets quickly define all the properties and edit metadata container and customize the database schema tree structure. + Lots of client-side optimizations led to a significant speedup of the UI. + The docker configuration file and script to dockerize the ASP.NET Core Cross-domain demo have been added. - Few localization fixes are made. - Cross-domain demo: all hosts are allowed now to enable CORS queries.
Active Query Builder History v.3.6.3.1162
+ Initial support for QuickBooks (QODBC) SQL syntax has been added. + Performance and memory consumption improvements on loading large database schema has been made. ! "Loaded" flags for object types and referencing foreign keys are saved now in metadata XML files to avoid unnecessary SQL queries to be fired. = SAP HANA: Minor fixes are made: DISTINCT before TOP, PLACEHOLDER before alias, NVARCHAR builtin type.
Active Query Builder History v.3.6.3.1162
= References to DevExpress WinForms controls are updated to v.20.1.3. + Initial support for QuickBooks (QODBC) SQL syntax has been added. + Performance and memory consumption improvements on loading large database schema has been made. ! "Loaded" flags for object types and referencing foreign keys are saved now in metadata XML files to avoid unnecessary SQL queries to be fired. = SAP HANA: Minor fixes are made: DISTINCT before TOP, PLACEHOLDER before alias, NVARCHAR builtin type.
Active Query Builder History v.3.6.3.1162
+ Initial support for QuickBooks (QODBC) SQL syntax has been added. + Performance and memory consumption improvements on loading large database schema has been made. ! "Loaded" flags for object types and referencing foreign keys are saved now in metadata XML files to avoid unnecessary SQL queries to be fired. = SAP HANA: Minor fixes are made: DISTINCT before TOP, PLACEHOLDER before alias, NVARCHAR builtin type. - Image sources are fixed now.
Active Query Builder History v.1.30.3
= Design Pane: Datasource captions are made more contrast. = Usability of building queries with grouping has been improved by a series of small fixes. + The new property QueryBuilder.SwapSidePanels has been added to swap the Database Schema Tree and the Query Structure Tree. - SQL Text Editor: Minor fixes and improvements for the suggestions list have been made. = SQL Text Editor: The new property SqlTextEditorOptions.SyncSuggestionLoading has been made for DACs having problems with running queries in threads. + Oracle: params and fields for stored procs, table functions loading fix = Oracle: Synonyms are loaded faster now. - Oracle: The bug in the QueryTransformer that led to incorrect query generation has been fixed. - SQL Server: Loading field comments for objects from non-default schemas and databases has been fixed. + PostgreSQL: Support for the WINDOW, FILTER clauses has been added. + SQLite: Support for the WINDOW and FILTER clauses and analytic expressions has been added. = SQLite, Teradata: Support for the REPLACE function has been fixed. = SAP Hana: Support for TOP and PLACEHOLDER clauses, NVARCHAR builtin type, CURRENT_UTC* constants have been added. + SAP Hana: Metadata filters are applied now to metadata fetching queries. - SAP Hana: Working with table functions has been fixed. = Nexus DB: Support for the TOP clause has been added. = Nexus DB: QueryTransformer now supports Skip and Take methods.
Active Query Builder History v.1.30.3
= Design Pane: Datasource captions are made more contrast. = Usability of building queries with grouping has been improved by a series of small fixes. + Oracle: params and fields for stored procs, table functions loading fix = Oracle: Synonyms are loaded faster now. - Oracle: The bug in the QueryTransformer that led to incorrect query generation has been fixed. - SQL Server: Loading field comments for objects from non-default schemas and databases has been fixed. + PostgreSQL: Support for the WINDOW, FILTER clauses has been added. + SQLite: Support for the WINDOW and FILTER clauses and analytic expressions has been added. = SQLite, Teradata: Support for the REPLACE function has been fixed. = SAP Hana: Support for TOP and PLACEHOLDER clauses, NVARCHAR builtin type, CURRENT_UTC* constants have been added. + SAP Hana: Metadata filters are applied now to metadata fetching queries. - SAP Hana: Working with table functions has been 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!