Active Query Builder Java Edition History

May 22, 2024

Active Query Builder Java Edition v.

- PostgreSQL: The bug with query to load db schema objects is fixed.

December 08, 2021

Active Query Builder Java Edition v.

= DB2: Support for the EXCEPTION JOIN id added; the backslash is now parsed as 
  a division in expressions.
- The NRE on fixing up some expressions on setting a condition in a grid cell is
- PostgreSQL: The "table.*" expression is accepted as an ordinary row expression
  term now.
= The Non-Visual Demo: minor improvements and code style fixes are made.

July 09, 2018

Active Query Builder Java Edition v.

- MySQL: The bug with getting the default database name has been fixed.
- Query Columns List: Grouped expressions are now loaded with the default
  condition type "For values".
- MSSQL: The ambiguity on parsing of the method call has been solved.
- Oracle: Parsing of the CYCLE identifier has been fixed.

September 07, 2015

Active Query Builder Java Edition v.

+ Support for IBM Netezza SQL syntax is added.
+ Support for AdvantageDB SQL syntax is added.
= PostgreSQL: Support for ANY, SOME, ALL predicates is made.
- DB2: Parsing of VALUES clause is fixed.

March 24, 2015

Active Query Builder Java Edition v.

! All manually entered aliases are quoted by default now.

February 27, 2015

Active Query Builder Java Edition v.

- Incorrect comparison of identificators in some rare cases is fixed.

January 26, 2015

Active Query Builder Java Edition v.

+ The new property is/setResolveColumnNamingConflictsAutomatically() is added
  to instruct the component to generate unique aliases for explicitly specified
  query columns to avoid duplicated column names.
+ The new property is added 
  to instruct the component to add aliases for unnamed fields 
  (expressions, aggregates) automatically.
= Recursion loop detection on building result SQL with virtual fields is made.
- Missing record is added for metadata object's alternate name in XML form of 
  query structure (QueryBuilder.QueryStatistics.QueryStructureXML).
- The bug with improper virtual objects alias expanding in column references 
  is fixed.
- Metadata comments fetching is fixed.
= All query parameter types are enabled now for all syntaxes.
= Informix: Syntax auto-detection and table list loading is improved.
= QueryColumnListControl now commits changes when you getting the 
  QueryBuilder.SQL property.
= The Linked Objects menu now shows "No linked objects" item if no linked 
  objects are found.
- Datasource references to metadata objects are always refreshed when setting 
  the SQL.
= Identifiers quotation in data source captions is removed.
- Parsing of long qualified names for some SQL syntaxes is fixed.
- Oracle: Loading of schemas containing no tables is fixed.
- Oracle: Metadata loading performance is improved.
= Oracle: Expression parsing optimisation is made.
- Oracle: Parsing of the REFERENCE keyword is fixed.
+ Oracle: The SEARCH and CYCLE clauses are now supported in CTE sub-queries.
- Oracle: Loading of foreign keys and user aggregates by unprivileged user is
- Firebird: Support for the WEEK date part is made.
- MySQL: Support for quoted characters in string literals is made.
- PostgreSQL: Parsing of common table expressions (CTE) is fixed.
= PostgreSQL: Parsing of ROW clause is improved.
- PostgreSQL: Support for RECURSIVE keyword in WITH clause is added.
+ MS SQL Server: New SQL Server 2012 analytic functions are added.
+ MS SQL Server: Support for IIF function and WITHIN GROUP clause is added.
- MS SQL Server: Parsing of function calls is fixed.
- MS SQL Server: Mistyped DATETIMEOFFSETFROMPARTS name is fixed.
- MS SQL Server Compact Edition: Version detection is fixed.
- MS Access: Query Builder now accepts identifiers quoted with backticks 
  and convert backticks to square brackets.
+ SQLite: Support for Common Table Expressions (CTE) is made.
+ SQLite: Support for backtick-quoted identifiers is made.

January 16, 2015

Active Query Builder Java Edition v.

- MS SQL Server: Expressions parsing is fixed.

April 29, 2014

Active Query Builder Java Edition v.

+ The new CustomMetadataTree source code sample is added.
- MS SQL Server: Parsing of aggregated functions is fixed.
- MS SQL Server: Parsing of method call chains is fixed.
- MySQL: DATE and TIME types parsing ambuiguities are eliminated.
- DB2, MySQL, PostgreSQL, ANSI SQL/92: DATE, TIME and TIMESTAMP literals
  are supported.
- DB2: Parsing of Hex, Graphics and Unicode string literals is fixed.

March 31, 2014

Active Query Builder Java Edition v.

= CustomTreeNode class is made public.

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