Active Query Builder 3 WinForms Edition History

January 29, 2021

Active Query Builder 3 WinForms Edition v.

= SAP HANA: Support for the CONVERT_UNIT built-in function is added.
= MS Access: Parsing of optional identifier before subquery in the FROM clause
  has been fixed.
- Generation of short aliases for names with more than 3 fragments has been
- SQL generation for objects added to the query by alternate name has been
- Design Pane: Primary and foreign key fields aren't hidden by the "Hide unused
  fields" command even if they aren't used in the query.
- Design Pane: Link attachment points are updated after showing or hiding unused

January 20, 2021

Active Query Builder 3 WinForms Edition v.

- MySQL: Support for UTC_* functions has been added.
- SQL Text Editor: Showing and hiding of suggestion popup has been fixed.
- The bug on clicking on an empty condition cell has been fixed.
- Other minor bugs are fixed.

January 13, 2021

Active Query Builder 3 WinForms Edition v.

= MySQL: Parsing of the RECURSIVE keyword in WITH clause has been fixed.
= SQL generation with UseAltNames option turned on has been fixed. 
- WinForms: Combobox property editor has been fixed. 
- The unhandled exception if there is a bad foreign key in metadata has been
- SQL generation for data export in the Full-featured MDI demo has been fixed.

January 02, 2021

Active Query Builder 3 WinForms Edition v.

= Minor internal improvements were made.

December 30, 2020

Active Query Builder 3 WinForms Edition v.

+ The new SqlGenerationOptions.ObjectNamesNormalization property is added
  to instruct the component to normalize object names found in the 
  query according to the database schema.
+ Short aliases for objects added to the query are generated automatically.
  Use BehaviorOptions.GenerateShortObjectAliases property to control this
+ The new panel is added to the top-right corner of the design pane to show or 
  hide unused fields.
- The bug with drag'n'drop of fields on the design pane has been fixed.
- PostgreSQL: PRECISION token is added to the list of valid identifiers.
- DevExpress: SQLTExtEditor default foreground color and font are fixed.

December 14, 2020

Active Query Builder 3 WinForms Edition v.

+ The new property MetadataItem.Visible is added to hide some objects and
  fields in UI.
+ The new bool property MetadataField.DisplayInLookup is added to mark fields
  that should be displayed to identify a record in lookup controls.
+ The new list property MetadataField.EnumValues is added to ease the 
  selection of enum-coded values.
= Metadata Container Editor: Metadata loading improvements are made.
= Azure SQL: Fetching field descriptions has been added.
- String aliases in subqueries are fixed
- QueryTransformer: The bug with loading columns with case-sensitive names
  is fixed.

November 25, 2020

Active Query Builder 3 WinForms Edition v.

+ Two methods are added to save and restore widths of columns set by the 
  user: QueryBuilder.QueryColumnListControl.SaveLayout and RestoreLayout.
+ It is now always possible to change the PERCENT and WITH TIES options 
  even if the TOP clause is not defined.
= References to DevExpress assemblies are updated to v.20.2.
= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- Minor parsing errors are fixed.
- Oracle: The bug with parsing names containing the PACKAGE component is
- DevExpress: The Add Object dialog is fixed.
- Add Object Dialog: Slow loading of tables and views is fixed. 

October 28, 2020

Active Query Builder 3 WinForms Edition v.

+ OLE DB, Sybase and Informix metadata providers are added for .NET Core.
- DevExpress: Compilation from the source code has been fixed.
- The addition of rows in the Query Column List by keyboard has been fixed.

October 22, 2020

Active Query Builder 3 WinForms Edition v.

+ Reports generation has been added to the Full-featured MDI demo for
  StimulSoft, ActiveReports, and FastReport.
- Hotkeys for row insertion in the Query Column List are corrected.
= Invariant culture is used for SQL tokens case conversion.

October 13, 2020

Active Query Builder 3 WinForms Edition v.

= SQL query loading and query statistics calculation have been speeded up.
= Oracle: Schema list loading has been speeded up.
+ PostgreSQL: Support for parenthesized subqueries has been added.
= Query Transformer: Queries with DISTINCT aren't wrapped in a subquery now 
  if the WHERE clause is empty.
- The bug with showing UserQuery fields in the Database Schema Tree after the
  search has been fixed.
- Numerous minor user interface bugs were fixed.

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