Active Query Builder WinForms Edition History

September 02, 2011

Active Query Builder WinForms Edition v.

- Fixed bug with uneditable "Or" columns when using DevExpress controls.
- Fixed bug with CriteriaListOptions.AutoSizeColumns property when using
  DevExpress controls.
= DevExpress dependencies of DevExpressControlFactory are updated to v11.1.7.0.

August 31, 2011

Active Query Builder WinForms Edition v.

+ The new methods are added to ease the query analysis and modifcation: 
  QueryBuilder.GetSubQueryList(), QueryBuilder.GetUnionSubQueryList(),
= Default value of "Criteria for" for non-aggregated query columns is changed
  "For groups" (HAVING) to "For values" (WHERE).
- Firing of the GetDiagramObjectWidth event for derived tables and CTE is fixed.
- Oracle: TRANSLATE function parsing is fixed.
- Fixed Grouping header's checkbox size in classic visual style.

August 25, 2011

Active Query Builder WinForms Edition v.

+ Tooltips are shown for fields in the DataSourceControl and objects in the
  MetadataTree. By default they show descriptions loaded from database server.
  You can customize tooltip text using new events GetDiagramObjectToolTipText
  and GetMetadataTreeToolTipText.
+ The new GetDiagramObjectWidth event is added to allow dynamic computing of
  diagram object width depending on its content.
- ExpressionEditor: The ObjectMetadataLoading event was not fired in offline
  mode on expanding table node.

August 23, 2011

Active Query Builder WinForms Edition v.

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
- MySQL: Foreign key relationships were inverted. Fixed now.
- PostgreSQL: Fixed parsing of SUBSTRING function and ARRAY literals.
- ExpressionEditor: The object searching does not expand object nodes if unable
  to load their fields.
- The problem with dropping metadata objects with the same AltName from the
  metadata tree is fixed.

August 22, 2011

Active Query Builder WinForms Edition v.

- ExpressionEditor: The LoadFieldsOnSearching property did not interfere with
  fields loading on manual expansion of nodes.

August 16, 2011

Active Query Builder WinForms Edition v.

- ExpressionEditor ans SqlTextExitor: The suggestion pup-up window is always
  top-most now and doesn't go beyond the bottom screen edge.
+ The new RefreshDatasourcesMetadata() method is added. Use it to update
  bindings between query and metadata objects. Might be useful if you modified 
  or reloaded metadata while a query is loaded in the query builder.
= MySQL references updated to version

July 29, 2011

Active Query Builder WinForms Edition v.

+ ExpressionEditor: New property LoadFieldsOnSearching instructs the component
  to load fields for database objects if they are not loaded yet. Setting this 
  property to true allows to search for fields even if they are not pre-loaded,
  but may lead to long waiting for search results on the first run.
- ExpressionEditor: Fixed objects and fields search.

July 28, 2011

Active Query Builder WinForms Edition v.

- The bug in ConvertDatasourceToDerivedTable() method is fixed.
- Fixed problem with deletion of orphaned links.

July 18, 2011

Active Query Builder WinForms Edition v.

+ The new UnionSubQuery.ConvertDatasourceToDerivedTable() method is added.

July 15, 2011

Active Query Builder WinForms Edition v.

+ UnionSubQuery class is updated: 
  Clear() method is added; SQL property { get; set } is added.

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