Active Query Builder 2 WinForms Edition History

May 27, 2014

Active Query Builder 2 WinForms Edition v.

+ The new MetadataItem.UserData property is added to allow storing custom data
  for any metadata object.

May 21, 2014

Active Query Builder 2 WinForms Edition v.

- MS Access: The parser now accepts identifiers quoted with backticks and
  convert them to square brackets.
- PostgreSQL: Parsing of common table expressions (CTE) is fixed.
- The crash on clicking on the Linked Objects button of sub-query data source
  is fixed.
= The Linked Objects menu now shows "No linked objects" item if no linked
  objects were found.

May 20, 2014

Active Query Builder 2 WinForms Edition v.

- MS SQL Server Compact Edition: Version autodetection is fixed.
= Full-Featured Demo: Support of alternate names is added.
- Link expressions were not updated on metadata changes. Fixed now.

May 05, 2014

Active Query Builder 2 WinForms Edition v.

- Generic Syntax Provider: Microsoft SQL Server Compact Edition autodetection
  is fixed.
- Empty brackets in datasource captions in some cases are fixed.

April 29, 2014

Active Query Builder 2 WinForms Edition v.

- MS SQL Server: Parsing of aggregated functions is fixed.
- DB2: Parsing of Hex, Graphics and Unicode string literals is fixed.
- MS Access: Built-in functions list is fixed.
- Minor fix in language files is made.

April 16, 2014

Active Query Builder 2 WinForms Edition v.

+ It is now possible to set different color for focused links using the
  QueryBuilder.DesignPaneOptions.LinkStyle.LinkColorFocused property.
= Virtual objects now obey UseAltNames property on virtual fields expansion phase.
= The source code of Query Modification Demo project is refactored.

April 11, 2014

Active Query Builder 2 WinForms Edition v.

+ Support for MS SQL Server 2014 is added.
+ The tool to conver metadata XML from the old v.1.x format to new is 
  available as .NET assembly ActiveDatabaseSoftware.MetadataXmlConverter.dll.
+ Quick Search in the Database Schema Tree is now able to search by field 
  names. Use the new property DatabaseSchemaTreeOptions.SearchFields to enable
  this feature.
= Database Schema Tree now emphasizes the search string with underscore.
- Add Object Form: The Enter key press response in the object list is fixed.
- DevExpress Controls Factory: Non-default tree sorting modes are fixed.
- OLE DB Metadata Provider: MetadataField.FieldType loading is fixed.
- MS SQL Server syntax: Parsing of method call chain is fixed.
- MySQL: DATE and TIME types parsing ambuiguities are eliminated.
- DB2, MySQL, PostgreSQL and ANSI SQL standards: DATE, TIME and TIMESTAMP
  literals are supported now.

April 02, 2014

Active Query Builder 2 WinForms Edition v.

+ The new BehaviorOptions.NotifyOnLinksCreatedAutomatically property is added 
  to let track addition of automatically created links (by foreign keys or by
  identical field names) using the LinkCreated event.

April 01, 2014

Active Query Builder 2 WinForms Edition v.

- OLE DB Metadata Provider: Incorrect column order when loading metadata from
  Excel file via Microsoft ACE 12.0 OLE DB Provider is fixed.
= Documentation is updated.

March 25, 2014

Active Query Builder 2 WinForms Edition v.

= CTE column aliases list is updated now when the underlying subquery is 
  changed by the user.
- A memory leak in UnionSubQuery.AddStoredProc method is eliminated.
- Errors in the XmlConverter.exe utility are 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