Active Query Builder 3 Core Edition History

April 04, 2020

Active Query Builder 3 Core Edition v.

- Minor bugfixes and improvements have been made.

March 20, 2020

Active Query Builder 3 Core Edition v.

- Query Transformer: The bug with not quoting column aliases when needed has 
  been fixed.
= SAP Hana: Support for the PLACEHOLDER clause has been added.
- SAP Hana: The TRIM function syntax has been corrected.

March 08, 2020

Active Query Builder 3 Core Edition v.

+ The missing Japanese localization has been added.
= The new MetadataItem.Connection property has been added to support the work 
  with MetadataContainer consolidating items from different DB connections.

February 28, 2020

Active Query Builder 3 Core Edition v.

+ SQLite: Support for window functions, analytic expressions, and the FILTER 
  clause has been added.
+ PostgreSQL: Support for the FILTER clause is added and the bug with the 
  PRECEDING clause is fixed.
= Teradata, ANSI SQL/89: Keywords and functions lists are filled.
= SQLite, Teradata, Generic: Support for the REPLACE function is added.
= The QueryColumnListItem.AddExpression method now fires an exception on
  adding an incorrect SQL expression instead of displaying an error to the
- Other minor bugs are fixed.

February 14, 2020

Active Query Builder 3 Core Edition v.

+ SAP Hana: Filters are now applied to the metadata fetching process.
+ Server version is detected by default now for Oracle, SQL Server, 
  MySQL, Sybase, and Informix.
= SAP Hana: The list of keywords has been updated.
= Oracle: Metadata loading has been speeded up.
= Oracle: Stored procedure fields are correctly loaded from the server now.
- Duplicated GROUP BY items are handled correctly now.

February 05, 2020

Active Query Builder 3 Core Edition v.

+ SAP Hana: Support for TOP clause has been added.
- SAP Hana: Parsing of CURRENT_UTC* constants is fixed.
+ The new type of namespace has been added: Connection.
+ The new ConsolidatedMetadataContainer demo is made to provide sample 
  of loading objects from several DB connections. 
= Installer: It is now possible not to uninstall the previous version.
= Installer: The request to elevate rights emerges now.
- Other minor bugs are fixed.

January 13, 2020

Active Query Builder 3 Core Edition v.

- Oracle: Minor bug in the QueryTransformer is fixed. Column prefixes for 
  inner queries are preserved now.

December 31, 2019

Active Query Builder 3 Core Edition v.

+ SAP Hana & ANSI Standard SQL Syntax: Support for the standard 
  TRIM(LEADING/TRAILING ...) builtin function is added.
- Oracle: The bug with loading objects from the PUBLIC schema is fixed.
- Oracle: Paging using the ROWNUM function in Oracle 11g and lower is fixed.
- MySQL: Parsing of the MATCH full-text search expression is fixed.

December 13, 2019

Active Query Builder 3 Core Edition v.

= The new helper method QueryColumnListItem.CreateAliasIdentifier has been 
  added to get a column name from the alias.
- The Null Reference Exception on loading OR conditions with brackets has
  been eliminated.
- Auto Syntax Provider: The Null Reference Exception on disposing of
  referencing objects has been fixed.
- Quotation of aliases and other identifiers with alternate quotation
  symbols has been corrected.
- The bug with adding HAVING conditions using the
  QueryColumnList.AddCondition helper has been fixed.

November 22, 2019

Active Query Builder 3 Core Edition v.

= New helper method has been made to add conditions to WHERE or HAVING:
  UnionSubQuery.QueryColumnList.AddCondition(ConditionType conditionType, 
  string condition).
- PostgreSQL: Support for WITH clause in subqueries has been added.
- MS SQL Server: Parsing of ordinal named parameters ("@0") has been restored.

Product Summary

 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!

Social networks