Softpedia >Windows >Programming >Components & Libraries >Active Query Builder Java Edition >  Changelog

Active Query Builder Java Edition Changelog

What's new in Active Query Builder Java Edition 1.9.2.1156

Dec 8, 2021
  • NonVisualDemo: minor improvements and code style fixes
  • Db2: add EXCEPTION join parsing, and parse backslash as division in expressions
  • Fix NRE on expression fixup for some expression kinds on setting condition in grid cell
  • PostgreSql: accept "table.*" as ordinary row expression term

New in Active Query Builder Java Edition 1.9.0.1153 (Oct 18, 2016)

  • + 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

New in Active Query Builder Java Edition 1.8.0.1152 (Mar 25, 2015)

  • All manually entered aliases are quoted by default now.

New in Active Query Builder Java Edition 1.8.0.1151 (Mar 25, 2015)

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

New in Active Query Builder Java Edition 1.8.0.1150 (Feb 27, 2015)

  • 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.

New in Active Query Builder Java Edition 1.7.3.1146 (Jan 26, 2015)

  • MS SQL Server: Expressions parsing is fixed.

New in Active Query Builder Java Edition 1.7.2.1143 (Jan 26, 2015)

  • 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.

New in Active Query Builder Java Edition 1.7.1.1142 (Jan 26, 2015)

  • CustomTreeNode class is made public.

New in Active Query Builder Java Edition 1.7.1.1141 (Jan 26, 2015)

  • Oracle: Зarsing of DATE, TIME and TIMESTAMP literals is fixed.
  • DB2: Minor parsing error is fixed.

New in Active Query Builder Java Edition 1.7.1.1140 (Jan 26, 2015)

  • Oracle: Support for interval expressions is added.
  • DB2: Using short object names if SYSTEM naming convention is used.

New in Active Query Builder Java Edition 1.7.1.1139 (Jan 26, 2015)

  • Exception on closing a data source is fixed.
  • Appearance of multi-links in the Add Linked Objects menu is fixed.

New in Active Query Builder Java Edition 1.7.1.1138 (Jan 26, 2015)

  • The Add Linked Objects menu now has separate items for each link if there are multiple links to the linked object.
  • MS SQL Server: Parsing of method calls is fixed.

New in Active Query Builder Java Edition 1.7.0.1137 (Jan 26, 2015)

  • The new AltNameCaseSensitive flag is added to all objects with Alt. names.

New in Active Query Builder Java Edition 1.7.0.1136 (Jan 26, 2015)

  • The bug with improper column names at visual link creation is fixed.

New in Active Query Builder Java Edition 1.7.0.1135 (Jan 26, 2015)

  • DB2: Loading of foreign keys is fixed.

New in Active Query Builder Java Edition 1.6.4.1133 (Dec 5, 2013)

  • Now the Query Builder keeps layout of design pane objects after manual changes of the query text.
  • Incorrect bracketing of inner OR in some cases is fixed.
  • Oracle: Fixed parsing of PARTITON with OUTER JOIN.
  • Oracle: Fixed support for unicode literals (N'abcdef').
  • Oracle: Fixed parsing of DENSE_RANK() function.
  • MSSQL: Added support for CLR method calls.
  • MSSQL: Improved the query for loading foreign keys from server.
  • PostgreSQL: Added support for multi-parameter aggregates.
  • PostgreSQL: Fixed parsing of ANY in codition cells.

New in Active Query Builder Java Edition 1.6.3.1132 (Aug 7, 2013)

  • Oracle: The "TIMESTAMP" identifier used as column name is allowed now.

New in Active Query Builder Java Edition 1.6.2.1130 (Jul 8, 2013)

  • Oracle: Unnecessary brackets in WHERE in some queries are eliminated.

New in Active Query Builder Java Edition 1.6.1.1127 (Apr 10, 2013)

  • Oracle: Support for named parameters in function call is added.
  • PostgreSQL: The bug with quoting some date time and system functions like CURRENT_DATE or USER when QuoteAllIdentifiers property is set to true is fixed.

New in Active Query Builder Java Edition 1.2.6.1027 (Apr 26, 2010)

  • The new context menu item "Add Common Table Expression" is added to the query building area.
  • Oracle: Server cursor leaks are eliminated.
  • MS Access: NULL is removed from list of valid identifiers.
  • Fixed wrong naming for query objects like "table.*" if more than one "table" used in the query.
  • MySQL: CONVERT function support is improved.
  • PostgreSQL: Metadata filter is fixed.
  • MetadataContainer.saveToXMLFile() did not close the file. Fixed now.

New in Active Query Builder Java Edition 1.1 (Jun 12, 2009)

  • Ability to localize the component and to define custom expression builder for the Expression and Criteria columns is made.

New in Active Query Builder Java Edition 1.0.5 (Jun 11, 2009)

  • Numerous demo projects to illustrate different aspects of the component's functionality: working with non-GUI tasks (programmatic SQL query creation, SQL parsing and modification), metadata filling, alternate names and events usage.