Below is the list of fixes and improvements in Active Query Builder Java Edition v.22.214.171.1240.
+ 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 CriteriaListOptions.is/setCreateColumnAliasesForUnnamedColumns() 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 fixed. - 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.
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!