Downloads  »  Active Query Builder Java Edition History

January 26, 2015

Active Query Builder Java Edition v.

Below is the list of fixes and improvements in 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.
[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder Java Edition at the download page.

» Full Active Query Builder Java Edition history

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