Downloads

Active Query Builder 2 WinForms Edition History

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.

April 18, 2018

Active Query Builder 2 WinForms Edition v.2.10.14.822

- SQLite: Parsing of queries with RIGHT and FULL joins now results in the
  parsing error.
- IBM DB2: NULL is parsed now as a constant, not as an identifier.
- MS SQL Server: Parsing of qualified names with skipped components has 
  been fixed.
- MS SQL Server: Loading of fields for linked servers without database or
  schema has been fixed.

March 15, 2018

Active Query Builder 2 WinForms Edition v.2.10.13.821

= Parsing of incorrect/incomplete "IN" expressions in condition cells of
  the Query Columns List has been improved.
= PostgreSQL parser has been optimized.
= Sqlite: Keywords list has been filled.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.
- MySQL: Support of STDDEV function has been fixed.

January 24, 2018

Active Query Builder 2 WinForms Edition v.2.10.12.820

+ Sybase: Support for window functions has been added.
= Numeric constants in ORDER BY are converted to corresponding expressions now.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  an arbitrary order has been fixed.
+ Oracle: Loading of stored procedure parameters from the server system
  catalog is supported now.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.

November 30, 2017

Active Query Builder 2 WinForms Edition v.2.10.11.819

+ Batch loading of fields and foreign keys for Oracle, MS SQL Server and 
  DB2 has been implemented.
+ The new SyntaxProvider.UseBatchMetadataLoading property has been added
  (default: True).
+ PostgreSQL: Support for "$n"-style positional parameters has been added.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Query Transformer: Applying both pagination and sort order has been fixed.
- Oracle: Unsupported comparison operators ("!>", "!<") have been removed.
- MySQL: Some valid identifiers were erroneously treated as keywords. 
  Fixed now.
- Oracle: List of keywords used as valid identifiers has been updated.
- MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been
  added.

August 23, 2017

Active Query Builder 2 WinForms Edition v.2.10.10.814

+ MS SQL Server: Support for SELECT into local variable has been added.
  (SELECT @localVar = ...)
- Criteria Builder: The bug with loading of BETWEEN conditions for date and
  datetime columns has been fixed.
- The bug with resolving baseName.fieldName references for stored procedures
  and table-valued functions has been fixed.

August 14, 2017

Active Query Builder 2 WinForms Edition v.2.10.9.812

- MetadataLoadingOptions.IncludeFilter/ExcludeFilter: filtration by object
  type only has been fixed.
- SQL Text Editor: Apostrophes in quoted identifiers don't break the 
  highlighting now.
- The QueryBuilder.LayoutSQL property now accept empty strings without
  errors.
- Correct column prefix now emitted for UDFs and stored procedures
  without aliases.

July 13, 2017

Active Query Builder 2 WinForms Edition v.2.10.8.810

+ MySQL: Support of MATCH full-text search operator has been made. 
= IBM DB2: The new DB2SyntaxProvider.ObeySchemaListFromDriver property has
  been added to ensure the priority of the list of objects received from
  the metadata provider (True by default). 
- IBM DB2: The bug with selecting table schema instead of table owner
  for schema name has been fixed. 
- The reference to MySql.Data assembly in MySQL metadata provider has been
  updated to the version 6.9.9. 
= MS SQL Server: List of reserved words has been updated. 
- Loading of foreign keys has been fixed. 
- The bug with quotation of incorrect SQL expressions with double quotes
  instead of apostrophes has been fixed. 
- MySQL: The "ORDER BY" clause in GROUP_CONCAT window function is kept now.

March 28, 2017

Active Query Builder 2 WinForms Edition v.2.10.7.809

= The new QueryBuilder.DatabaseSchemaTreeController property has been added
  to get public access to the Database Schema Tree controller.

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