Downloads

Active Query Builder 3 WinForms Edition History

July 24, 2017

Active Query Builder 3 WinForms Edition v.3.3.14.1062

= The new property DatabaseSchemaView.Controller has been added.
- The AllowEdit check before the ValidateContextMenu call in the CustomTreeView
  has been removed.

July 19, 2017

Active Query Builder 3 WinForms Edition v.3.3.13.1061

+ PostgreSQL, MySQL, SQLite, Netezza: Support for SQL expressions in the
  LIMIT/OFFSET clauses has been added.
+ The new StreamLog class has been added. It can be used to log the 
  metadata extraction process via the Logger.Log property of SQLConext,
  MetadataProvider and SyntaxProvider objects.
- The bug with registering controls in the Toolbox of Visual Studio 2017 
  has been fixed.
= Demo projects are grouped by folders in the solution.
= MS SQL Server: List of reserved words has been updated.
- MySQL: The "ORDER BY" clause doesn't eat now in the GROUP_CONCAT window
  function.
- Invalid SQL expressions in the Query Columns List are quoted now as
  strings, not as identifiers.

July 05, 2017

Active Query Builder 3 WinForms Edition v.3.3.12.1060

= Demo projects have been updated and fixed.
- Registration of controls in the Visual Studio 2017 Toolbar has been fixed.
- The exception in the Properties Bar in design mode has been fixed.
- The bug with Expression editor not reflecting values of conditions
  correctly has been fixed.
- The bug with displaying tables from sub-queries in the main query has
  been fixed.

June 26, 2017

Active Query Builder 3 WinForms Edition v.3.3.11.1059

- Query properties for the main query are displayed correctly now.
- Minor bugs have been fixed.

June 23, 2017

Active Query Builder 3 WinForms Edition v.3.3.11.1058

+ SQL Text Editor: The new LoadMetadataOnCodeCompletion property has been
  added. It prescribes to load metadata if it hasn't been loaded yet on
  displaying the suggestion popup list.
! The bug with loading of conditions joined with OR has been fixed.
  They were converted to AND in some cases.
- Query Transformer: The bug on transforming the query with a stored 
  procedure has been fixed.
- Loading of foreign keys has been fixed.
- Other minor bugs have been fixed.

June 16, 2017

Active Query Builder 3 WinForms Edition v.3.3.10.1057

! The bug that caused slow initialization of the component, especially on
  the large database schema has been fixed. 
= The MetadataItem.FindItems(filter, type) method now takes
  the filter.ObjectType property into account.
= MetadataObject.Expression property setter now checks expression for
  recursion loops. 
- The bug with quotation of incorrect SQL expressions with double quotes
  instead of apostrophes has been fixed.

June 09, 2017

Active Query Builder 3 WinForms Edition v.3.3.9.1056

+ The new events are added to track addition and removal of items in the
  Query Columns List. 
  QueryColumnListControl: ItemAdded and ItemRemoving;
  QueryBuilder: QueryColumnListItemAdded, QueryColumnsListItemRemoving.
- Commands for adding and managing sub-queries in expressions are moved to
  the context menu of appropriate cells. The ellipsis button now immediately
  displays the Expression Editor.
- IBM DB2: Database objects are now loaded from the server if loading from
  driver fails.

June 02, 2017

Active Query Builder 3 WinForms Edition v.3.3.8.1055

- The critical bug with loading of top-level AND conditions has been fixed. 
+ The new DisableQueryNavigationBarPopup property has been added to the
  QueryBuilder.PanesConfigurationOptions group.
+ The new IDatabaseSchemaView.SQLGenerationOptions property has been added
  to alter displaying of object names in the tree. 
+ Database connection logging is possible now.
- Hiding of columns in the Query Transformer hadn't get applied immediately.
  Fixed now. 
- MS SQL Server: Object name is now used as default alias for objects from
  linked servers. 
- The MetadataStructureItem.GetDisplayCaption method has been speeded up.

May 26, 2017

Active Query Builder 3 WinForms Edition v.3.3.7.1054

= Conditions for the same left part joined using the OR operator are merged
  into a single cell now.
- IBM DB2: The method to retrieve the list of schemas now falls back to SQL
  query if loading from driver returns no schemas.
- Referencing objects for User Queries aren't loaded now.

April 28, 2017

Active Query Builder 3 WinForms Edition v.3.3.6.1053

= ODBC Metadata Provider: Better detection of servers that don't support
  schemas has been made.
= SQL 92 Syntax Provider allows empty schema names now.

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