Downloads

Active Query Builder 3 WPF Edition History

December 13, 2017

Active Query Builder 3 WPF Edition v.3.3.25.1073

+ Sybase: Support for window functions has been added.
= User Queries: Exception is thrown now if query expression has output
  column names conflicts.
= Teradata: Minor metadata loading improvements have been made.
- SQL Text Editor: The bug with caret position after removing a character
  and scrolling has been fixed.
- SQL Text Editor: The bug with the content of suggestion window not taking
  the last input character into account has been fixed.
- Loading of stored procedure parameters from metadata XML files has been
  fixed.
= Fields in datasources can be checked with the space key now.

November 30, 2017

Active Query Builder 3 WPF Edition v.3.3.24.1072

- Query Transformer: Applying both pagination and sort order has been fixed.
= SQL Text Editor: "Dual" has been added to the list of suggestions for
  Oracle.

November 27, 2017

Active Query Builder 3 WPF Edition v.3.3.24.1071

- Restoring layout of datasources in the query after manual changing the
  query has been fixed.
+ The new "Go To Expression" context menu item has been added for 
  sub-queries in expressions.
+ New properties have been added to the AddObjectWindowOptions group: 
  Width, Height, Position, Location, ImageIndices.
= Query Column List: Conditions recognition and correction has been
  improved.
- User Queries Structure assignment has been fixed.
= The QueryStatistics.IsStatisticsValid flag has been hidden. 
+ Oracle: Batch fields and relations loading has speeded up metadata
  loading.
- Oracle: Unsupported comparison operators ("!>", "!<") have been removed.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Firebird: Parsing of Aggregate functions has been fixed.
- The bug with dragging CTE from the query navigation bar to the Design 
  Pane has been fixed.
- Other improvements and bug fixes have been made.

October 18, 2017

Active Query Builder 3 WPF Edition v.3.3.23.1070

- The bug with expanding custom metadata structure items has been fixed.
- The crash on searching in the Database Schema Tree has been eliminated.
- The bug with not clearing the ORDER BY clause on assigning new text to
  a sub-query.

October 13, 2017

Active Query Builder 3 WPF Edition v.3.3.22.1069

= Parsing of large Oracle SQL queries has been speeded up.
+ The new Link.ReferencedDataSources property has been added.
+ The new UserQueriesControl.SelectedItemChanged event has been added. 
= Creation of referencing loops of virtual objects is not possible now.
- Drag'n'drop in the User Queries Control has been fixed. 
- The bug with presence of the "empty node" item in folders of the User
  Queries Control has been fixed.
- MySQL: Parsing of DateDiff function has been fixed.
- The bug with localization of the Add Object Dialog has been fixed.
= The new "Execute Query" action has been made in the Full-Featured MDI 
  Demo project.

September 27, 2017

Active Query Builder 3 WPF Edition v.3.3.21.1068

- MySQL: Some valid identifiers were erroneously treated as keywords. 
  Fixed now.
- The bug with selection from the drop-down list of Expression column in 
  the Query Columns List has been fixed.

September 26, 2017

Active Query Builder 3 WPF Edition v.3.3.21.1067

+ PostgreSQL: Support for "$n"-style positional parameters has been added.
- Drop-down editors in the Query Columns List have been fixed.
- Unwanted switch to the main query on adding new sub-query has been fixed.

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.

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:

Tweets