Active Query Builder 2 WinForms Edition History

February 18, 2014

Active Query Builder 2 WinForms Edition v.

= The Add Linked Objects menu now has separate items for each link if there are
  multiple links to the linked object.
- Fetching comments for MSAccess, PostgreSQL, MySQL, Firebird and DB2 is fixed.
- Query Transformer: Filtration by column with aggregate is fixed.

January 29, 2014

Active Query Builder 2 WinForms Edition v.

- Query Transformer: Filtration by columns with analytic expressions is fixed.
- DevExpressControlFactory: The DataSourceOptions.ShowDescriptionTooltips and
  DataSourceOptions.DescriptionTooltipsDelay properties are fixed.

January 27, 2014

Active Query Builder 2 WinForms Edition v.

+ QueryTransformer: The new ExportToXML() and ImportFromXML() methods are 
  added to allow serialization of transformations to XML.
+ The new MetadataLoadingOptions.DisableAutomaticMetadataLoading property 
  is made to let disabling of automatic metadata loading on query parsing.
+ The new properties are added to control description tooltips over the
  datasources and database schema tree.
  The ShowDescriptionTooltips and DescriptionTooltipsDelay properties are
  added to the DataSourceOptions and DatabaseSchemaTreeOptions groups.
- QueryTransformer: Column expression is used in WHERE clause instead of alias.
= Documentation is updated.

January 21, 2014

Active Query Builder 2 WinForms Edition v.

- MS SQL Server: Loading of metadata object descriptions is fixed.
= The ClearSearchBox() method now acts immediately (was delayed).
= Search related methods IsSearching(), StopSearch(), ClearSearchResults() are
  made public.

January 20, 2014

Active Query Builder 2 WinForms Edition v.

+ Virtual objects and fields are present in the Query Statistics among with 
  real objects expanded from virtual objects. 
  The new IsFromQuery and IsFromVirtual boolean properties are added to 
  StatisticsDatabaseObject and StatisticsField classes. 
  The IsFromQuery property is true if an object explicitly present in the query,
  the IsFromVirtual property is true if an object is expanded from a virtual
  object. Both properties can be set to true at a time if an object exists in
  the query in both ways.
+ Add Object Form: The "Show all objects..." item is shown among with the list
  of metadata structure nodes (usually namespaces). Double clicking on it
  displays flat list of all underlying objects.
+ The ClearSearchBox() public method is added.
= Universal Metadata Provider: The "TABLES" schema table is used now to fetch
- Clearing text in the search box before start of the search process is fixed.
- The bug with improper virtual objects alias expanding in column references
  is fixed.

January 14, 2014

Active Query Builder 2 WinForms Edition v.

+ Search is made in the Add Object form.
= DevExpress references are updated to v.
- Query builder was showing default icons in the search results instead of icons
  set by user in the MetadataStructureOptions. Fixed now.

December 30, 2013

Active Query Builder 2 WinForms Edition v.

+ Search in the database schema tree is made.
+ The new properties are added to the DatabaseSchemaTreeOptions:
  SearchBoxVisible, SearchBoxDocking.
+ Alternate names are added to the query structure XML

December 20, 2013

Active Query Builder 2 WinForms Edition v.

+ The new PaintDesignPaneToBitmap() method is added for exporting the design pane
  content to an image.

December 06, 2013

Active Query Builder 2 WinForms Edition v.

= The icon for referencing objects menu item has been changed.
- Recursion loop detection on building result SQL with virtual fields is made.
- Oracle: The schema loading query is corrected to load schemas that have no
  tables, but contain other types of database objects.
- Query Transformer: Filters were applied incorrectly to wrapped queries.
  Fixed now.

November 26, 2013

Active Query Builder 2 WinForms Edition v.

! The bug with broken ReferencedObject name in ForeignKey is fixed.
= Items in the Linked Objects menu now sorted alphabetically.
- Loading of joins in WHERE clause with subqueries referencing other
  datasources is fixed.
- PostgreSQL: Support for ORDER BY in aggregate functions is added.
- MS SQL Server: "PARSE" is valid identifier now.
- MS SQL Server: The conflict between "char", "nchar" identifiers and 
  same-named built-in functions is solved.
= MS SQL Server: Parsing of nested function calls is optimized for speed.

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