Active Query Builder 2 WinForms Edition History

November 30, 2017

Active Query Builder 2 WinForms Edition v.

+ 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

August 23, 2017

Active Query Builder 2 WinForms Edition v.

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

- 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
- Correct column prefix now emitted for UDFs and stored procedures
  without aliases.

July 13, 2017

Active Query Builder 2 WinForms Edition v.

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

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

March 17, 2017

Active Query Builder 2 WinForms Edition v.

+ SQLite: Support for the IS operator ("expr IS expr") has been added.
+ The new MetadataLoadingOptions.AllowRecursiveVirtualObjects property
  allows specifying the mode of working with virtual objects. By default,
  referring to other virtual objects in the text of a virtual object is
  allowed. Such reference lets build a chain of objects to break complex
  queries in a series of simple ones. However, in this mode, you can't use
  the same-named physical object in a virtual object because of the emerging
  recursion. Setting this property to false prohibits creation chains of
  virtual objects, but allows to create virtual objects that substitute
  physical database objects.
= Automatic links creation for self-linked objects has been improved.
  (from Parent to Child or Child to Parent, not both)
= Constant expressions aren't appended to the grouping list now.
= Default namespace prefixes aren't skipped in the Database Schema Tree now.
= Better unique table alias generation has been made.
= Quoted AltName value is set now by default to the DataSource.NameInQuery
- MS SQL Server: Built-in @@-named variables are recognized now.
- Oracle: Date/time built-in constants are recognized properly now.
- MS SQL Server: DATEPART parser ambiguity has been fixed.

January 25, 2017

Active Query Builder 2 WinForms Edition v.

+ PostgreSQL: Support of materialized view, TOAST tables and foreign tables 
  has been made. 
+ Oracle: Support of the "AT TIME ZONE" clause has been added.
+ Firebird: Column name definition after alias in the FROM clause is
  supported now.
+ IBM DB2: The ListAgg function is supported now.
+ Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields
  collections now include invalid objects and fields being used in the
  query. They differ from valid objects by the absence of MetadataObject
  (for objects) and MetadataField (for fields) references.
- Detection of recursion loops in virtual objects definition has been made.
- Default UI culture is used to format values in Criteria Builder.
- MySQL: Parsing of DATE, TIME, and DATETIME types as keywords has been

December 20, 2016

Active Query Builder 2 WinForms Edition v.

= References to DevExpress controls have been updated to the v.
= MS SQL Server: Custom aggregates aren't loaded now from linked servers.
- MySQL: Proper fixup of string aliases has been made to avoid control hang
  on some queries.

December 08, 2016

Active Query Builder 2 WinForms Edition v.

- Firebird: Support of the simple form of TRIM function has been fixed.
- Oracle: Support for the special form of TRIM function has been fixed.
- Displaying of Varchar(Max) and Varbinary(Max) data types in the datasource
  fields list has been fixed.
- Calculation of checked fields in the datasource fields list has been
- Parsing of the single-line comments has been fixed.
- MS SQL Server: List of valid identifiers has been updated.
- SQLite: Support for the string concatenation operator ("||") is fixed.

October 14, 2016

Active Query Builder 2 WinForms Edition v.

+ Aggregate and builtin functions list is cached now to speed up large 
  query text generation.
= MetadataItem: InvalidOperationException is thrown now if both 
  MetadataName and MetadataItem property values are specified.
= UnionSubQuery.AddDatasource*At method: if any of the drop coordinates
  is negative, drop position is calculated automatically. Note that this
  method treats given coordinates as absolute screen coordinates.
- MS SQL Server: CHAR(n) parser ambiguity is fixed.
- MS SQL Server: ROW and ROWS are added to the list of valid identifiers.

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: