Downloads

Active Query Builder 3 WinForms Edition History

September 22, 2017

Active Query Builder 3 WinForms Edition v.3.3.20.1066

- 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 WinForms Edition v.3.3.19.1065

+ 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 WinForms 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 WinForms 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 WinForms 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.
- 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 25, 2017

Active Query Builder 3 WinForms 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 WinForms 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 WinForms 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.
= 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 WinForms Edition v.3.3.12.1060

= Demo projects have been updated and fixed.
- Registration of controls in the Visual Studio 2017 Toolbar has been fixed.
- The exception in the Properties Bar in design mode 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 WinForms Edition v.3.3.11.1059

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