Downloads

Active Query Builder 3 Core Edition History

June 02, 2017

Active Query Builder 3 Core Edition v.3.3.8.1055

+ Database connection logging is possible now.
- The critical bug with loading of top-level AND conditions has been fixed. 
- MS SQL Server: Object name is now used as default alias for objects from
  linked servers. 
- The MetadataStructureItem.GetDisplayCaption method has been speeded up.

May 26, 2017

Active Query Builder 3 Core Edition v.3.3.7.1054

- IBM DB2: The method to retrieve the list of schemas now falls back to SQL
  query if loading from driver returns no schemas.

April 28, 2017

Active Query Builder 3 Core Edition v.3.3.6.1053

= ODBC Metadata Provider: Better detection of servers that don't support
  schemas has been made.
= SQL 92 Syntax Provider allows empty schema names now.

April 25, 2017

Active Query Builder 3 Core Edition v.3.3.6.1042

- Minor refactorings have been made.

April 18, 2017

Active Query Builder 3 Core Edition v.3.3.5.1041

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

March 24, 2017

Active Query Builder 3 Core Edition v.3.3.4.1040

- Minor bugfixes have been made.

March 21, 2017

Active Query Builder 3 Core Edition v.3.3.3.1039

= Code cleanup.

March 17, 2017

Active Query Builder 3 Core Edition v.3.3.2.1038

+ Installer: Integration with Visual Studio 2017 has been added.
= Oracle: Recognition of built-in constants has been improved.
= MS SQL: Recognition of built-in @@-named variables has been improved.
- The bug with removing of the "TOP n" clause in the query text has been
  fixed.
- User Queries structure tree isn't reloaded now on every SQL query change.
= Constant expressions aren't appended to the grouping list now.

March 06, 2017

Active Query Builder 3 Core Edition v.3.3.1.1037

+ SQLite: Support for the IS operator ("expr IS expr") has been added.
= Automatic links creation for self-linked objects has been improved.
- The bug with re-applying metadata filters has been fixed.
- Minor bugfixes have been made.

February 27, 2017

Active Query Builder 3 Core Edition v.3.3.0.1036

+ The new helper class Core.UserQueries that consists of static methods has
  been added to perform various manipulations with user queries, such as
  adding, saving, moving, renaming them. It also has the means to save and
  load user queries serialized in XML format.
+ 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.
+ The new SQLite metadata provider has been added.
= The Query Structure demo project has been refactored.
- Removal of unused objects from the query when the
  QueryBuilder.BehaviorOptions.DeleteUnusedObjects property is turned to 
  True has been fixed.