Downloads

Active Query Builder 3 WPF Edition History

May 11, 2016

Active Query Builder 3 WPF Edition v.3.1.0.1018

+ The component now tries to fix invalid aliases in the query on loading.
+ The new property MaxToolTipWidth is added to the DesignPane and
  DatabaseSchemaView controls to define maximum width of tooltips.
- Saving changed of cell values in the Query Column List after clicking 
  on another cell is fixed. 
- A reference to the property of main window is removed in Expression
  Editor. 
- Collapsing/expanding of datasouce from the context menu is fixed.
- Placement of the datasource context menu is fixed. 
- The error on loading expression item to the Query Column List before 
  the control is displayed has been fixed.

May 08, 2016

Active Query Builder 3 WPF Edition v.3.1.0.1016

- Specific assemblies security fixes for NET Framework 4 are made.

May 06, 2016

Active Query Builder 3 WPF Edition v.3.1.0.1015

= Database Schema View is scrolled to top after initialization. 
= Minor compilation warnings are removed. 
- Activation wizard is fixed.
- Field names calculation for aliased expressions in sub-queries is fixed.
- Base Metadata Provider: Query to load fields for procedures is fixed.
- Null reference exception on aborting addition of table after double
  clicking on a field in Database Schema Tree is fixed.

April 29, 2016

Active Query Builder 3 WPF Edition v.3.1.0.1014

- Assignment of aliases for aggregated columns is fixed.
- Multiple fixes in Database Schema View and Query Columns List are made.
- Source code compilation is fixed.
- Localization is fixed.

April 22, 2016

Active Query Builder 3 WPF Edition v.3.0.5.1013

+ The Load Metadata Demo project is added.
= Text wraping in tooltips is made.
= Oracle: DBA* views are used now for metadata loading if available.
= Alternate names are used now for adding datasource by double click in 
  the Database Schema View.
- MS SQL Server: Loading additional information about fields from 
  non-default  databases is fixed.
- Query Columns List Control: Copying existing expression and pasting it
  to a new row is fixed.
- Tooltips for non-visible items of datasource field list aren't shown
  anymore.
- Several bugfixes in the Database Schema View are made.
- A memory leak when adding a datasource on Design Pane is eliminated.
= Link lines on Design Pane are drawn on the background.
- The bug on adding a table to the query after double clicking on a node 
  of the Database Schema View is fixed.

April 15, 2016

Active Query Builder 3 WPF Edition v.3.0.5.1012

- Clearance of the Database Schema View in different situations is fixed.
- The Null reference error on setting values of DescriptionTooltipsDelay and 
  SortingType properties of the DatabaseSchenaViewOptions is eliminated.
= The MetadataForeignKey.ReferencedObject property now accepts alternate
  names.

April 08, 2016

Active Query Builder 3 WPF Edition v.3.0.5.1010

= MS SQL Server: Parsing speed is improved.
- Layout of controls in the Add Object Dialog is fixed. 
- In some cases in the Database Schema tree in flat mode items weren't 
  cleared correctly. Fixed now.

April 07, 2016

Active Query Builder 3 WPF Edition v.3.0.5.1009

+ Oracle: Database links support is made. 
  To make objects from database links visible in Database Schema Tree, turn 
  the the QueryBuilder.MetadataLoadingOptions.LoadDafaultDatabaseOnly 
  property to False.
+ Sybase: Metadata retrieval from SAP IQ is made.
+ Flat view for the Database Schema Tree control is made. The new property
  QueryBuilder.DatabaseSchemaTreeOptions.ViewMode is added. Set it to Flat
  to turn the control into new mode. Default value is Tree.
- The DatasourceAdding event is fired in all cases of adding object to the
  query by end-user.
- MS SQL Server: Fetching stored procedure parameters from system catalog 
  is fixed.
- DB2: Fetching description for synonyms is fixed.
- Teradata: Fields are sorted by default by ColumnId.
- The behaviour of the MetadataFilterItem.Exclude setter is corrected. 

March 23, 2016

Active Query Builder 3 WPF Edition v.3.0.4.1008

+ Chinese (Taiwan) translation is added.
= Database Schema Tree: Descriptions for synonyms are taken from referred
  objects if it's not defined for synonym itself.
+ The new Query Transformer demo is added.
- Overlapping items bug in DataSource control is fixed.
- Clicking on a non-focused check box in the Visible column of Query 
  Columns List didn't affect the state. Fixed now.
- SQL Text Editor: Word wrapping is fixed.
- Advantage DB: The "use object names as default alias" flag is turned on.
- Now the hints for fields in DataSource field lists are hidden after 
  right clicking on a DataSource.
- Trial: Random aliases are kept the same for result query generated by the
  Query Transformer.
- Database Schema Tree: Only field nodes are shown under the table nodes
  now.
- Query Transformer: SQL wasn't updated on changing the column.Visible
  property. Fixed now.
- Drawing of arrows at the end of links in case of Left/right outer joins
  is fixed.
- Parsing of the "in (subquery)" expressions in condition cells is fixed.
- The OracleSyntaxProvider.IsSupportSubQueryCTE is set correctly now.
- The bug with reseting SortType to Ascending after setting the 
  QueryColumnListItem.SetSortOrder property is fixed.

March 02, 2016

Active Query Builder 3 WPF Edition v.3.0.3.1007

+ Non-Visual Demo is added.
- StatisticsOutputColumn: Origin* properties calculation for CTE is fixed.
- Add Object Dialog: Filter button is fixed.
- Database Schema View: Loading of large database schema is speeded up.
- Query Column List Control: Exception is fixed.
- Query Column List Control: Ellipsis button of the last row is fixed.