Active Query Builder 3 Core Edition History

June 26, 2020

Active Query Builder 3 Core Edition v.

= QuickBooks: Support for square-brackets quoted identifiers has been added.

June 10, 2020

Active Query Builder 3 Core Edition v.

= QuickBooks (QODBC): Support for 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 Core 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.

May 16, 2020

Active Query Builder 3 Core 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.
- Localization of messages in .NET Core assemblies has been fixed.

May 08, 2020

Active Query Builder 3 Core Edition v.

+ The Metadata Container Editor executable is included in the Professional 
  and Trial installation packages.
+ 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.
= 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 Core Edition v.

- Minor bugfixes and improvements have been made.

March 20, 2020

Active Query Builder 3 Core Edition v.

- Query Transformer: The bug with not quoting column aliases when needed 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 Core Edition v.

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

+ 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.
= Teradata, ANSI SQL/89: Keywords and functions lists are filled.
= 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
- Other minor bugs are fixed.

February 14, 2020

Active Query Builder 3 Core Edition v.

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

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