Downloads

Active Query Builder History History

July 24, 2017

Active Query Builder History v.3.3.14.1062

= The new property DatabaseSchemaView.Controller has been added.
- The AllowEdit check before the ValidateContextMenu call in the CustomTreeView
  has been removed.

July 24, 2017

Active Query Builder History v.3.3.14.1062

= The new property DatabaseSchemaView.Controller has been added.
- The AllowEdit check before the ValidateContextMenu call in the CustomTreeView
  has been removed.

July 22, 2017

Active Query Builder History v.1.27.4

- Compilation errors for C++Builder have been fixed.
- Minor fixes for the Full-featured demo project have been made.
! Demo projects are moved to the %ALLUSERSPROFILE%\Documents\ActiveDbSoft\Demos"
  folder (usually "C:\Users\Public\Documents\ActiveDBSoft\Demos".

July 20, 2017

Active Query Builder History v.1.27.3

- The bug with applying result column names for queries with asterisk items
  when fields aren't loaded yet has been fixed.
- Filtration by aggregated columns has been fixed.

July 20, 2017

Active Query Builder History v.1.27.3

+ The new Professional version is available now. It includes the Advanced
  SQL Text Editor, SQL Expression Editor, and the SQL Filter Builder.
  The Full-featured demo project now exists in two variants: one for the
  Standard, other for the Professional version. The Trial version includes
  both variants. 
+ The new demo projects have been made: Create Query demo and Edit Metadata
  Container demo.
- The bug with applying result column names for queries with asterisk items
  when fields aren't loaded yet has been fixed.
- Filtration by aggregated columns has been fixed.

July 19, 2017

Active Query Builder History v.3.3.13.1061

+ PostgreSQL, MySQL, SQLite, Netezza: Support for SQL expressions in the
  LIMIT/OFFSET clauses has been added.
+ The new StreamLog class has been added. It can be used to log the 
  metadata extraction process via the Logger.Log property of SQLConext,
  MetadataProvider and SyntaxProvider objects.
- The bug with registering controls in the Toolbox of Visual Studio 2017 
  has been fixed.
= Demo projects are grouped by folders in the solution.
= MS SQL Server: List of reserved words has been updated.
- MySQL: The "ORDER BY" clause doesn't eat now in the GROUP_CONCAT window
  function.
- Invalid SQL expressions in the Query Columns List are quoted now as
  strings, not as identifiers.

July 19, 2017

Active Query Builder History v.3.3.13.1061

+ PostgreSQL, MySQL, SQLite, Netezza: Support for SQL expressions in the
  LIMIT/OFFSET clauses has been added.
+ The new StreamLog class has been added. It can be used to log the 
  metadata extraction process via the Logger.Log property of SQLConext,
  MetadataProvider and SyntaxProvider objects.
- The bug with registering controls in the Toolbox of Visual Studio 2017 
  has been fixed.
= Demo projects are grouped by folders in the solution.
= MS SQL Server: List of reserved words has been updated.
- MySQL: The "ORDER BY" clause doesn't eat now in the GROUP_CONCAT window
  function.
- Invalid SQL expressions in the Query Columns List are quoted now as
  strings, not as identifiers.

July 19, 2017

Active Query Builder History v.3.3.13.1061

+ PostgreSQL, MySQL, SQLite, Netezza: Support for SQL expressions in the
  LIMIT/OFFSET clauses has been added.
+ The new StreamLog class has been added. It can be used to log the 
  metadata extraction process via the Logger.Log property of SQLConext,
  MetadataProvider and SyntaxProvider objects.
- The bug with registering controls in the Toolbox of Visual Studio 2017 
  has been fixed.
- Moving the popup window of Expression column combo box up and down on
  switching between rows has been eliminated.
- The Expression editor not properly reflecting values of criteria for 
  "OR" columns has been fixed.
- Cells of custom columns of the Query Columns List is refreshed after 
  edit correctly now.
- The bug with collapsing datasource field list after adding a link has 
  been fixed.
- Drag'n'drop is disabled in the Database Schema Tree now.
= Demo projects are grouped by folders in the solution.
= MS SQL Server: List of reserved words has been updated.
- MySQL: The "ORDER BY" clause doesn't eat now in the GROUP_CONCAT window
  function.
- Invalid SQL expressions in the Query Columns List are quoted now as
  strings, not as identifiers.

July 14, 2017

Active Query Builder History v.2.13.13

- The bug with resizing of datasource on Design Pane has been fixed.
= Diagnostic error message is now shown if there's no access to the session
  store.
= MS SQL Server: List of keywords has been updated.

July 13, 2017

Active Query Builder History 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.