Downloads

Active Query Builder History History

January 02, 2021

Active Query Builder History v.3.7.9.1184

= Minor internal improvements were made.

December 30, 2020

Active Query Builder History v.3.7.8.426

= Minor improvements have been made.

December 30, 2020

Active Query Builder History v.3.7.8.1183

+ 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
  behavior.
+ 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 30, 2020

Active Query Builder History v.3.7.8.1183

+ 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
  behavior.
+ 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 30, 2020

Active Query Builder History v.3.7.8.1183

+ 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
  behavior.
- PostgreSQL: PRECISION token is added to the list of valid identifiers.

December 21, 2020

Active Query Builder History v.1.30.7

= PostgreSQL: Support for the parenthesized subqueries has been added.
= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- MySQL: The bug with the special syntax of POSITION has been fixed.

December 21, 2020

Active Query Builder History v.1.30.7

+ Support for the QuickBooks SQL syntax is added (xsQuickBooks = 140)
= PostgreSQL: Support for parenthesised subqueries has been added.
= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- MySQL: The bug with the special syntax of POSITION has been fixed.

December 14, 2020

Active Query Builder History v.3.7.7.425

+ The new thread-safe GetOrCreate helper method is added to initialize an 
  instance of the QueryBuilder and QueryTransformer objects properly.
= An exception is thrown if QueryTransformer is used without a QueryBuilder.
= Fields with the MetadataItem.Visible property set to false are hidden from
  datasource field list.
- Numerous bug fixes are made.

December 14, 2020

Active Query Builder History v.3.7.7.1182

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

December 14, 2020

Active Query Builder History v.3.7.7.1182

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

scroll to top
© Copyright 2005-2022 ActiveDBSoft. All rights reserved.
Site Map Terms of Use Privacy Policy

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:

News

Tweets

Testimonials

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