Active Query Builder 3 WPF Edition History

July 27, 2020

Active Query Builder 3 WPF Edition v.

= ODBCMetadataProvider: new properties are added to turn off some specific
  driver features that sometimes can improve the performance: 
  IgnoreSchemaOnlyFlag and SkipLoadFieldsFromGetSchema.
- MySQL: Logical conditions aren't suffixed with "=True" or "=False" anymore.
- IBM DB2: System views are checked for existence before querying them.

July 12, 2020

Active Query Builder 3 WPF Edition v.

+ Support for Snowflake DB SQL syntax has been added.
+ The SubQuery Navigation Bar now lets you know more about sub-query usage 
  at one sight: query part, operator, correlatedness.
= Searching in the Add Object Dialog is corrected.
= SQL Server: The connection form lets define new authentication options
  for Azure databases.
- Minor fixes in the Query Columns Grid have been made.
- Assemblies are removed correctly now after uninstalling the product.

July 02, 2020

Active Query Builder 3 WPF Edition v.

= The BehaviorOptions.LinkManipulations property is taken into account when
  creating a new link using datasource context menus, notification events are 
  fired correctly then.
= On trying to link a table to itself, a copy of that table is added to the 
  query and linked accordingly.
- The bug with multiline field descriptions drawn on the same line is fixed.

June 26, 2020

Active Query Builder 3 WPF Edition v.

+ Users now can create links from UI separately indicating fields to
  start and finish a new link via the datasource field context menu.
+ Three new events are added to the CriteriaBuilder control:
  NeedEditorForValue, NeedCustomLookupButton, NeedCustomLookupControl.
  They allow for using custom editors for values of specific fields or
  data types.
+ The new demo project CriteriaBuilderCustomize is added to illustrate 
  the way how one can use custom editors, buttons and controls in the 
  CriteriaBuilder control.
+ Source code of the Metadata Container Editor is included in a set of
  demo projects for Trial and Professional versions.
= Criteria Builder: minor fixes and improvements are made.
= QuickBooks: Support for square-brackets quoted identifiers has been added.
- The bug with checking/unchecking an asterisk item in datasources is fixed.

June 10, 2020

Active Query Builder 3 WPF Edition v.

+ Metadata loading errors are displayed now via the notification bar.
+ The new property QueryBuilder.BehaviorOptions.AllowMessageTypes is added 
  to determine the types of messages to be shown in the notification bar.
+ The new property QueryBuilder.DesignPaneOptions.DesignPaneOverviewMaxHeight
  is added to determine the maximum ratio (range from 0 to 1) of the overview
  pane height and overall Design Pane height. 
  The actual width and height of the overview pane is now calculated 
  according to new and DesignPaneOverviewWidth properties.
= Significant performance improvements are made.
= QuickBooks (QODBC): Support for the TOP clause is added, support for derived 
  tables is turned off.
= PostgreSQL: Backslash quotation for generic string literals has been removed.
= Metadata serialization to XML: The "Loaded" flag for all types of objects
  is now set on for a namespace if child database objects of any type exist.

June 01, 2020

Active Query Builder 3 WPF Edition v.

+ Initial support for QuickBooks (QODBC) SQL syntax has been added.
+ Performance and memory consumption improvements on loading large database 
  schema has been made.
! "Loaded" flags for object types and referencing foreign keys are saved 
  now in metadata XML files to avoid unnecessary SQL queries to be fired.
= SAP HANA: Minor fixes are made: DISTINCT before TOP, PLACEHOLDER before 
  alias, NVARCHAR builtin type.
- Image sources are fixed now.

May 16, 2020

Active Query Builder 3 WPF Edition v.

+ 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 WPF Edition v.

+ 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.
= It's now possible to zoom in/out objects on the Design pane using the 
  Ctrl+Plus/Minus and Ctrl+MouseWheel shortcuts.
= 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.
= 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 WPF Edition v.

+ 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
+ Support for the Right-to-left oriented layout has been made.
+ Hebrew and Dutch localizations have been added; other localizations are
= The programmer now has full control over the context menus.

March 20, 2020

Active Query Builder 3 WPF Edition v.

= 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.

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:



We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks