Downloads

Active Query Builder 3 WPF Edition History

September 22, 2017

Active Query Builder 3 WPF Edition v.3.3.20.1066

- The bug on loading component with non-empty query inside the Telerik RAD
  panel has been fixed.
- The bug on entering a value to the cell of Query Columns List control 
  that doesn't exist in a combo box suggestion list has been fixed.
- The bug with visibility of the Design Pane Preview area has been fixed.
- The bug with the links remaining on the Design Pane after clearing the
  query has been fixed.
- Oracle: List of keywords used as valid identifiers has been updated.
- MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been
  added.
= Methods to save and load user queries to XML have been moved to the 
  SQLContext class.
- Minor bugfixes and improvements have been made.

September 13, 2017

Active Query Builder 3 WPF Edition v.3.3.19.1065

+ The Design Pane Preview area has been made to let quickly navigate over
  large diagrams.
+ The new StatisticsField.IsDirectlyMentioned property has been added. 
  It indicates whether a field is directly mentioned in the query or just
  appears in the query result as a result of the expansion of an asterisk
  item ("*") in the SELECT list.
= User queries structure has been moved from the UserQueries control to 
  the SQLContext.UserQueriesStructure property.
- SQL Text Editor: Word wrapping has been fixed.

August 25, 2017

Active Query Builder 3 WPF Edition v.3.3.18.1065

+ MS SQL Server: Support for SELECT into local variable has been added.
  (SELECT @localVar = ...)
- The bug with resolving baseName.fieldName references for stored procedures
  and table-valued functions has been fixed.
- The bug with not refreshing fields for objects in the main query via 
  RefreshDatasourcesMetadata call has been fixed.
- The bug with not allowing to expand object type grouping nodes (Tables,
  Views, ...) in the Database Schema Tree has been fixed.

August 18, 2017

Active Query Builder 3 WPF Edition v.3.3.17.1064

+ Text Editor: Oracle LISTAGG function template has been added. 
= StreamLog: The underlying stream is flushed now on every write. 
- CriteriaBuilder: Loading conditions with BETWEEN operator for datetime
  columns has been fixed. 
- PostgreSQL: Autodetection has been fixed in the Auto Syntax Provider. 
- Syntax detection process is logged now in the Auto Syntax Provider.

August 11, 2017

Active Query Builder 3 WPF Edition v.3.3.16.1063

+ The new IDatabaseSchemaView.ValidateItemContextMenu event has been made.
  It lets customize context menu of the Database Schema Tree items. 
+ The new IDatabaseSchemaView.ExpandItem has been made to expand the tree
  down to the specified item and scroll down to it.
+ Position of an invalid object can be obtained from the SQLParsingException
  on parsing a query when ParsingErrorOnUnknownObjects property is set to
  True.
- Crash in the Expression Editor while changing the value has been fixed.
- Drag & drop of objects from the Database Schema Tree to Design Pane has
  been fixed.
- MetadataLoadingOptions.IncludeFilter/ExcludeFilter: filtration by object
  type only has been fixed.
- Caret position on mouse clicking in the TextEditor has been corrected.
- 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 25, 2017

Active Query Builder 3 WPF Edition v.3.3.15.1063

+ The new IDatabaseSchemaView.ValidateItemContextMenu event has been added
  to allow the creation of custom context menu for items in the Database 
  Schema Tree. 

July 24, 2017

Active Query Builder 3 WPF Edition 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 19, 2017

Active Query Builder 3 WPF Edition 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 05, 2017

Active Query Builder 3 WPF Edition v.3.3.12.1060

= Demo projects have been updated and fixed.
- Registration of controls in the Visual Studio Toolbar has been fixed.
- The bug with setting focused cell in the Query Columns Grid after changing
  the SQL text has been fixed.
- The bug with Expression editor not reflecting values of conditions
  correctly has been fixed.
- The bug with displaying tables from sub-queries in the main query has
  been fixed.

June 26, 2017

Active Query Builder 3 WPF Edition v.3.3.11.1059

- Query properties for the main query are displayed correctly now.
- Minor bugs have been fixed.