Downloads

Active Query Builder 2 WinForms Edition History

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.

October 04, 2019

Active Query Builder 2 WinForms Edition v.2.10.17.828

= References to the DevExpress assemblies are updated to v.19.1.
= PostgreSQL: Handling of "partial" expressions like "=1" is improved.

February 08, 2019

Active Query Builder 2 WinForms Edition v.2.10.16.827

= DevExpress control factory: References are updated to the v.18.2.
+ MySQL: Support for Common Table Expressions in MySQL 8+ has been made.
- PostgreSQL: Parsing of the AT TIME ZONE operator has been fixed.
- MS Access: The bug with TRUE and FALSE constants parsing has been fixed.
- Oracle: The bug with columns for objects from linked DBs has been fixed.
- PostgreSQL: Parsing ambiguities for INTERVAL and AT TIME ZONE have been
  eliminated. 
= MS SQL Server: Column aliases for functions are allowed now.
- The bug with loading queries having ordering by indexes and an asterisk 
  in the SELECT list has been fixed.

October 09, 2018

Active Query Builder 2 WinForms Edition v.2.10.15.825

+ Oracle: Support for ranking functions has been improved.
= Loading of fields with data type unsupported by a database driver is made
  more reliably now.
- PostgreSQL: Parsing of "EXTRACT(epoch FROM ...)" function has been fixed.

May 25, 2018

Active Query Builder 2 WinForms Edition v.2.10.15.823

= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
- Teradata: The bug with autodetection of new versions has been fixed.

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:

Tweets

Testimonials

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