Downloads

Active Query Builder 3 WinForms Edition History

May 16, 2020

Active Query Builder 3 WinForms Edition v.3.6.2.1161

+ The new event MetadataContainer.MetadataLoadingError is added to take 
  additional actions on error executing queries to retrieve database schema.
+ The new event MetadataContainer.MetadataLoadingErrorNotification event is 
  added to display notifications about errors executing metadata retrieval 
  queries. One can suppress displaying error notifications to users by 
  handling the MetadataLoadingError event and setting its Abort parameter to
  True to suppress firing of the MetadataLoadingErrorNotification event.
+ Logging of the metadata retrieval queries is fixed and improved.
- SQL Text Editor: The bug in the Find and Replace dialog on firing search 
  with an empty pattern has been fixed.
- Localization of messages in .NET Core assemblies has been fixed.

May 08, 2020

Active Query Builder 3 WinForms Edition v.3.6.1.1160

+ Query Navigation Bar: The new way to display the path to subqueries is made. 
  Now when you switch to a subquery, a breadcrumb displaying the path from 
  the main query to the current subquery is drawn; subqueries that don't belong 
  to the current subquery are hidden.  This mode is turned on by default. 
  You can switch it off by setting the QueryBuilder.QueryNavBarOptions.
  ShowPathToCurrentSubQuery property to False.
+ The Metadata Container Editor executable is included in the Professional 
  and Trial installation packages.
= Existing object is linked when creating a new join rather than adding 
  a new object, but only if it's not yet linked in another way.
= Predefined SQL expressions are indicated with their names instead of SQL 
  expression texts in the field context menu.
= It is now easy to add more than one folder to the root.
= "Object" is not displayed as a field data type anymore when it's not 
  possible to determine it.
+ Syntax providers: The new property QueryToLoadFieldsTemplate allows for 
  customizing the query to load the list of fields for an object.
+ Metadata providers: The new property CommandTimeout allows for changing 
  the timeout for metadata loading queries.
- Scaling in the WinForms and DevExpress controls UI is fixed.
= The default value of MetadataStructureOptions.GroupByTypes property is 
  changed to True.
= Oracle: Objects of excluded types (tables, views, procedures, synonyms)
  aren't loaded to the MetadataContainer anymore.
- Oracle: Synonyms for objects that are not loaded to the metadata container 
  aren't hidden now to speed-up a load of synonyms.
= Consolidated Metadata Container demo: The "Show DataSources stats" button 
  is added.

April 04, 2020

Active Query Builder 3 WinForms Edition v.3.6.0.1159

+ The indication of sorting, aggregation, and conditions for a column in the
  object field list on Design Pane has been made.
+ The new way to define sorting, grouping, aggregations, and sorting via the
  context menu of the datasource field list has been introduced. It also
  helps to switch to the existing condition in the Query Columns grid.
+ It's possible now to define a set of ready-to-use conditions for specific
  fields and data types for instant applying via the datasource field list
  context menu.
+ The user can switch now to sub-queries in WHERE and HAVING parts of the
  query using a button next to a corresponding field in the datasource field
  list.
+ Support for the Right-to-left oriented layout has been made.
+ Hebrew and Dutch localizations have been added; other localizations are
  updated.
= The programmer now has full control over the context menus.

March 20, 2020

Active Query Builder 3 WinForms Edition v.3.5.40.1158

= Now the user can apply conditions to expression value (in the WHERE clause)
  for an aggregated column. (choose "For values" in the "Criteria for" column)
= The "Grouping" flag isn't set now for a newly added column on adding it to 
  the query by double-clicking on a field in the Design Pane.
- The bug with not displaying the link creation buttons in datasources in the
  Design Pane when fields are custom-drawn using the FieldListDrawItem event.
- Query Transformer: The bug with not quoting column aliases when needed has 
  been fixed.
- The bug with adding an incorrect CTE item from the Sub-query Navigation 
  panel has been fixed.
= SAP Hana: Support for the PLACEHOLDER clause has been added.
- SAP Hana: The TRIM function syntax has been corrected.

March 08, 2020

Active Query Builder 3 WinForms Edition v.3.5.39.1157

+ The missing Japanese localization has been added.
= The new MetadataItem.Connection property has been added to support the work 
  with MetadataContainer consolidating items from different DB connections.

February 28, 2020

Active Query Builder 3 WinForms Edition v.3.5.38.1156

+ SQLite: Support for window functions, analytic expressions, and the FILTER 
  clause has been added.
+ PostgreSQL: Support for the FILTER clause is added and the bug with the 
  PRECEDING clause is fixed.
= SQL Text Editor: The missing methods ShowSuggestionWindow and 
  HideSuggestionWindow are added.
= Teradata, ANSI SQL/89: Keywords and functions are added to the suggestion 
  list in the SQL Text Editor.
= SQLite, Teradata, Generic: Support for the REPLACE function is added.
= The QueryColumnListItem.AddExpression method now fires an exception on
  adding an incorrect SQL expression instead of displaying an error to the
  user.
- The Ctrl+Alt+Insert hotkey command in the Query Column List control has
  been fixed.
- The bug with displaying field names on the design pane in the 
  right-to-left mode has been fixed.
- Other minor bugs are fixed.

February 14, 2020

Active Query Builder 3 WinForms Edition v.3.5.37.1155

+ SAP Hana: Filters are now applied to the metadata fetching process.
+ Server version is detected by default now for Oracle, SQL Server, 
  MySQL, Sybase, and Informix.
= SAP Hana: The list of keywords has been updated.
= Oracle: Metadata loading has been speeded up.
= Oracle: Stored procedure fields are correctly loaded from the server now.
- Duplicated GROUP BY items are handled correctly now.
- DevExpress: The exception arose by deleting a data source from the Design
  pane has been eliminated.

February 05, 2020

Active Query Builder 3 WinForms Edition v.3.5.36.1154

+ SAP Hana: Support for TOP clause has been added.
- SAP Hana: Parsing of CURRENT_UTC* constants is fixed.
= The Basic demo has been improved.
+ The new type of namespace has been added: Connection.
+ The new ConsolidatedMetadataContainer demo is made to provide sample 
  of loading objects from several DB connections. 
= Installer: It is now possible not to uninstall the previous version.
= Installer: The request to elevate rights emerges now.
= Database Schema View: Database Exceptions on expanding nodes are properly
  handled now and displayed to the user.
- Database Schema View: The wait label is now displayed during the load of
  search results.
- Database Schema View: The bug on adding an object to Favorites from the 
  search results has been fixed.
- ODBC metadata properties form: Properties are applied correctly now.
- Other minor bugs are fixed.

January 13, 2020

Active Query Builder 3 WinForms Edition v.3.5.35.1153

- Oracle: Minor bug in the QueryTransformer is fixed. Column prefixes for 
  inner queries are preserved now.
- SQL Formatting Options frames are added to the VB.NET Full-Featured MDI 
  demo.

December 31, 2019

Active Query Builder 3 WinForms Edition v.3.5.34.1152

+ SAP Hana & ANSI Standard SQL Syntax: Support for the standard 
  TRIM(LEADING/TRAILING ...) builtin function is added.
- Oracle: The bug with loading objects from the PUBLIC schema is fixed.
- Oracle: Paging using the ROWNUM function in Oracle 11g and lower is fixed.
- MySQL: Parsing of the MATCH full-text search expression is fixed.