Downloads

Active Query Builder 3 WinForms Edition History

April 08, 2016

Active Query Builder 3 WinForms 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 WinForms 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. 
- Hiding hints for fields in DataSource field lists is fixed.

March 23, 2016

Active Query Builder 3 WinForms 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.
+ New demos are added to WinForms version: Query UI Events Demo, Interface 
  Customization Demo, Datasource Fields Linking by Drag'n'Drop Demo
- SQL Text Editor: Word wrapping is fixed.
- Advantage DB: The "use object names as default alias" flag is turned on.
- 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.
- Parsing of the "in (subquery)" expressions in condition cells is fixed.
- The OracleSyntaxProvider.IsSupportSubQueryCTE is set correctly now.
- The error on using Quick search in the Add Object Dialog is fixed.
- The bug with reseting SortType to Ascending after setting the 
  QueryColumnListItem.SetSortOrder property is fixed.

March 02, 2016

Active Query Builder 3 WinForms Edition v.3.0.3.1007

- StatisticsOutputColumn: Origin* properties calculation for CTE is fixed.
- Query Column List Control: Ellipsis button of the last row is fixed.

February 20, 2016

Active Query Builder 3 WinForms 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 WinForms 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.
- 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. 

December 18, 2015

Active Query Builder 3 WinForms Edition v.3.0.1.1004

- Minor bugfixes are made.

December 15, 2015

Active Query Builder 3 WinForms 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.

December 11, 2015

Active Query Builder 3 WinForms Edition v.3.0.0.1002

= First public BETA version.