Downloads

Active Query Builder 2 WinForms Edition History

April 26, 2022

Active Query Builder 2 WinForms Edition v.2.10.27.838

= References to DevExpress assemblies are updated to v.21.2.7.
= Query Columns List: Logical expressions such as EXISTS subqueries aren't set
  as visible automatically, but used for filtration purposes by default.
- The bug with not printing aliased object names is fixed.
- Criteria Builder: The display of condition values is fixed.
= MS SQL Server: Support for "FOR JSON" clause is added.
= MS SQL Server: Support JOIN without a type prefix is made.
- PostgreSQL: The bug with loading referencing objects list is fixed.
= Oracle: Support for default value clause for conversion functions is added.
- SAP Hana: Parsing of YEAR/HOUR/MINUTE/... builtin functions is fixed.
- MS SQL Server: The TIME built-in type parsing is fixed.

January 25, 2022

Active Query Builder 2 WinForms Edition v.2.10.26.837

= MS SQL Server: Support of the AT TIME ZONE operator is added.
+ SAP Hana: Support for analytic expressions is made.
= Informix: The bug with parsing keywords used as identifiers is fixed.
= References to DevExpress assemblies are updated to v.21.2.5.

November 15, 2021

Active Query Builder 2 WinForms Edition v.2.10.25.836

+ ODBC Metadata Provider: Loading fields using the ODBC GetSchema method is
  implemented.
+ ODBC Metadata Provider: The new SkipLoadFieldsFromGetSchema property is added
  to not use the GetSchema method if its implementation is buggy or slow in 
  some of the ODBC drivers.

November 10, 2021

Active Query Builder 2 WinForms Edition v.2.10.24.835

= Informix: Keywords list is updated, support for double-quoted strings 
  support (with auto-detection) and curly-braced comments is added.
= MS SQL Server: Support for TRY_CAST and TRY_CONVERT built-in functions is 
  added.
= Teradata: A fallback to non-X system views if X-views are not available is
  made.
= MySQL: Fields are fetched sorted by ORDINAL_POSITION.
= Firebird: Support for CTE in subqueries is turned on.
- SAP Hana: The bug with schemas loading is fixed.

May 27, 2021

Active Query Builder 2 WinForms Edition v.2.10.23.834

= MS SQL Server: Only the default database is loaded from the server now 
  if the MetadataLoadingOptions.LoadDefaultDatabaseOnly is set to true to
  speed up the load.
= References to DevExpress assemblies are updated to v.21.1.
= SAP HANA: Support for the CONVERT_UNIT built-in function is added.
= MS Access: Parsing of optional identifier before subquery in the FROM
  clause has been fixed.
= DB2: Parsing of the EXCEPTION join and parsing backslash as a division in 
  expressions are fixed.
- MySQL: "POSITION" is added to the list of valid identifiers.
- MySQL: The bug with PRECEDING keyword parsing is fixed.
- MySQL: Support for UTC_* functions has been added.
= MySQL: Parsing of the RECURSIVE keyword in WITH clause has been fixed.
- PostgreSQL: PRECISION token is added to the list of valid identifiers.

December 01, 2020

Active Query Builder 2 WinForms Edition v.2.10.22.833

= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- Oracle: The bug with parsing names containing the PACKAGE component is
  fixed.
- MySQL: The bug with the special syntax of POSITION has been fixed.

August 04, 2020

Active Query Builder 2 WinForms Edition v.2.10.21.832

- SAP Hana: Minor SQL generation fixes are made.
- MySQL: Minor fixes for queries with the "~" character.

July 01, 2020

Active Query Builder 2 WinForms Edition v.2.10.20.831

+ Support for QuickBooks SQL dialect has been added.
+ Support for SAP Hana SQL dialect has been added.
+ PostgreSQL: Support for the DISTINCT ON clause has been made.
= PostgreSQL: Backslash quotation for generic string literals has been dropped.

June 02, 2020

Active Query Builder 2 WinForms Edition v.2.10.19.830

= References to DevExpress WinForms controls are updated to v.20.1.3.
+ PostgreSQL: Support for the FILTER clause is added and the bug with the 
  PRECEDING clause is fixed.
= SQLite, Teradata, Generic: Support for the REPLACE function is added.
+ SQLite: Support for window functions, analytic expressions, and the FILTER 
  clause has been added.
- MySQL: Parsing of the MATCH full-text search expression is fixed.
- PostgreSQL: Support for WITH clause in subqueries has been added.
- MS SQL Server: Parsing of ordinal named parameters ("@0") has been
  restored.
- Informix: Support for sub-queries has been fixed.
- Generic Syntax Provider: loads metadata from Oracle fine now.

October 12, 2019

Active Query Builder 2 WinForms Edition v.2.10.18.829

= Informix: Support for new built-in functions (LEFT, RIGHT) has been added.
+ Informix: Support for derived tables for IDS11+ has been made.
- PostgreSQL: Comparison operators precedence has been corrected.