Downloads

Active Query Builder 3 WPF Edition History

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.

February 20, 2016

Active Query Builder 3 WPF Edition v.3.0.2.1006

+ Query Statistics: New properties are added to the StatisticsOutputColumn
  class to ease determination of origin of a column in case it comes from
  derived table or CTE: OriginDatasource, OriginMetadataObject and
  OriginMetadataField.
- Metadata Structure: Custom field nodes in the database schema tree are
  fixed now.
- Setter of the QueryColumnListItem.SortOrder property is fixed.
= MS SQL Server: Parsing performance is improved.
- MS SQL: "COLLATE" reserved word after the column expression is allowed.
- Firebird: Generation of the FIRST and SKIP clauses by QueryTransformer
  is fixed.
+ BaseSyntaxProvider: The new server capability flag is added for future SQL 
  syntaxes: support of aliases in GROUP BY clause (IsSupportGroupByAlias).
= Default value of the DatabaseSchemaViewOptions.SortingType property is 
  changed to NameExceptFields.
= QueryColumnList: Ellipsis button in expression and condition columns is 
  always shown now. It displays item context menu.
- SQL Text Editor:  Incorrect behavior on pressing Ctrl-Right keys at the end 
  of the text is fixed now.
- TextEditor: The error on pressing Ctrl-Up and Ctrl-Down keys is fixed.
- Other minor bugs are fixed.

February 05, 2016

Active Query Builder 3 WPF Edition v.3.0.2.1005

+ Query Navigation Bar: Drag and drop in navigation bar and it's popups is 
  possible to reorder unions and to add exiting CTE or derived table to the 
  current sub-query.
+ Query Navigation Bar gets scrolled in case of large list of unions or 
  sub-queries; the new QueryNavigationBar.PopupMaxHeight property is made.
+ The new WPF source code sample projects were added: 
  = Custom Expression Builder demo: implementation of custom dialog to edit 
    experssions and conditions in the Query Columns List;
  = Datasource Fields Linking demo: customization of the component's 
    behavior on dragging and dropping fields on Design Pane to create links;
  = Interface Customization demo: addition custom controls to datasources on 
    Design Pane;
  = Query UI Events: customization of the component's behavior on changing 
    different parts of queries visually.
  = Query Columns List Custom Columns demo: adding custom columns to the Query
    Columns List.
- Keyboard navigation in the Query Column List Control with arrow keys is fixed.
- Query column with an aggregate wasn't checked on Design Pane. Corrected now.
- MS SQL Server: Parsing of the DateAdd function is fixed.
- Incorrect stored procedure naming when dropping it to design pane is fixed.
  (if a procedure is in non-default schema, invalid query was generated)
- Exception on clicking on the datasource's link button on Design Pane is fixed. 
- Binding of join lines on Design Pane to left or right side of DataSource 
  control is corrected. 
- Displaying of field type size in DataSource control is corrected.

December 18, 2015

Active Query Builder 3 WPF Edition v.3.0.1.1004

+ New WPF source code samples are added Alternate Names, Drag&Drop Demo,
  Custom Columns Demo.

December 15, 2015

Active Query Builder 3 WPF Edition v.3.0.1.1003

+ Data type computation in expressions is made for Oracle.
= Recognition of date and string literals, and lists of literals in the 
  IN clause is improved for Criteria columns.
- ODBC literals and function call syntax is fixed in all syntax providers.
- PostgreSQL: UESCAPE support in unicode string literals is fixed.
- Oracle: Support for ListAgg and XmlAgg in analytic expressions is fixed.
- MS SQL Server: Date parts are added to the list of valid identifiers.
= The ValidateQuery() method now throws exception if SELECT list is empty.