Downloads

Active Query Builder History History

September 02, 2011

Active Query Builder History v.1.17.7

= QueryStatistics.OutputColumns.ExpressionAlias is now unquoted.
= Conditions aren't turned to HAVING automatically for grouped query columns.
+ The new methods are added to ease the query analysis and modifcation: 
  TacQueryBuilder.GetSubQueriesList and GetUnionSubQueriesList,
  TacUnionGroup.GetUnionSubQueriesList.
- Oracle: TRANSLATE function is fixed.

September 02, 2011

Active Query Builder History v.1.15.7.324

- 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 History v.1.15.7.323

+ The new methods are added to ease the query analysis and modifcation: 
  QueryBuilder.GetSubQueryList(), QueryBuilder.GetUnionSubQueryList(),
  UnionGroup.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 26, 2011

Active Query Builder History v.1.4.4.1082

- MySQL: Foreign key relationships were inverted. Fixed now.
- PostgreSQL: Fixed parsing of SUBSTRING function and ARRAY literals.
+ 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.

August 25, 2011

Active Query Builder History v.1.17.6

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
- Adding objects with same AltName from the database objects tree is fixed.

August 25, 2011

Active Query Builder History v.1.17.6

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
= Now using DevExpress PageControl v3 by default.
= DevExpress controls package names are corrected.
- Adding objects with same AltName from the database objects tree is fixed.

August 25, 2011

Active Query Builder History v.1.15.6.322

+ 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 History v.1.17.5

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
- MySQL: Reversed displaying of foreign key relationships is fixed.
- Exception is not raised now if the OleInitialize call is failed. 
  It's necessary for OLE drag'n'drop functionality.
- PostgreSQL: Parsing of SUBSTRING function and ARRAY literals is made.

August 23, 2011

Active Query Builder History v.1.17.5

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
- MySQL: Reversed displaying of foreign key relationships is fixed.
- Exception is not raised now if the OleInitialize call is failed. 
  It's necessary for OLE drag'n'drop functionality.
- PostgreSQL: Parsing of SUBSTRING function and ARRAY literals is made.
= The new TacQueryBuilder.RefreshDatasourcesMetadata function is made. It is
  needed to allow metadata refreshing without reloading of the current SQL text.

August 23, 2011

Active Query Builder History v.1.15.5.321

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

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