Active Query Builder History v.1.26.15
= MS SQL Server: Parsing performance is improved. - Query Columns List: The fix for "Aggregate" and "Grouping" columns auto-fit is made.
Active Query Builder History v.1.26.14
+ The new property is added to the CustomExpressionEditorParams object to determine the index of condition/or column: ConditionIndex. + Fitting of the Query Column List's column width on double clicking on the column splitter is made. = The missing property Scale is added to the IMetadataField interface. = Addition or modification of expressions via the OnCustomExpressionEditor event handler now follows the same rules as changing them via the query building UI by end-user. (eg. checking of the Visible field for new rows, assigning aliases to resolve column name conflicts, etc.)
Active Query Builder History v.1.26.14
+ The new property is added to the TacCustomExpressionEditorParams object to determine the index of condition/or column: ConditionIndex. + Fitting of the Query Column List's column width on double clicking on the column splitter is made. = Addition or modification of expressions via the OnCustomExpressionEditor event handler now follows the same rules as changing them via the query building UI by end-user. (eg. checking of the Visible field for new rows, assigning aliases to resolve column name conflicts, etc.)
Active Query Builder History v.2.10.9
- The bug with dragging objects with quoted full name from Database Schema Tree to Design Pane is fixed.
Active Query Builder History v.1.26.13
= Firebird: Domain name is shown now instead of type name in datasource field lists. - Database Schema Tree wasn't scrolled to the top after reload. Fixed now. - The SubQuery.Clear clears the WITH clause as well.
Active Query Builder History v.1.26.13
+ The new SQL syntax feature to use aliases in GROUP BY is added: TacBaseSyntaxProvider.IsSupportGroupByAlias property. = Firebird: Domain name is shown now instead of type name in datasource field lists. - Database Schema Tree wasn't scrolled to the top after reload. Fixed now. - The SubQuery.Clear clears the WITH clause as well.
Active Query Builder History v.2.10.8
- Query Result Demo is adapted for .NET Framework 4.5.
Active Query Builder History v.2.10.5.757
= DevExpress references are updated to v 15.2.5.0. - Query column with an aggregate wasn't checked on Design Pane. Corrected now. - SQL Text Editor: The behaviour on pressing Ctrl-Right keys in the end of the text is corrected.
Active Query Builder History v.3.0.2.1005
+ Query Navigation Bar: Drag and drop in navigation bar and it's popups is possible to reorder unions and to add exiting CTE or derived table to the current sub-query. + Query Navigation Bar gets scrolled in case of large list of unions or sub-queries; the new QueryNavigationBar.PopupMaxHeight property is made. - Keyboard navigation in the Query Column List Control with arrow keys is fixed. - Query column with an aggregate wasn't checked on Design Pane. Corrected now. - MS SQL Server: Parsing of the DateAdd function is fixed. - Incorrect stored procedure naming when dropping it to design pane is fixed. (if a procedure is in non-default schema, invalid query was generated) - Exception on clicking on the datasource's link button on Design Pane is fixed.
Active Query Builder History v.3.0.2.1005
+ Query Navigation Bar: Drag and drop in navigation bar and it's popups is
possible to reorder unions and to add exiting CTE or derived table to the
current sub-query.
+ Query Navigation Bar gets scrolled in case of large list of unions or
sub-queries; the new QueryNavigationBar.PopupMaxHeight property is made.
+ The new WPF source code sample projects were added:
= Custom Expression Builder demo: implementation of custom dialog to edit
experssions and conditions in the Query Columns List;
= Datasource Fields Linking demo: customization of the component's
behavior on dragging and dropping fields on Design Pane to create links;
= Interface Customization demo: addition custom controls to datasources on
Design Pane;
= Query UI Events: customization of the component's behavior on changing
different parts of queries visually.
= Query Columns List Custom Columns demo: adding custom columns to the Query
Columns List.
- Keyboard navigation in the Query Column List Control with arrow keys is fixed.
- Query column with an aggregate wasn't checked on Design Pane. Corrected now.
- MS SQL Server: Parsing of the DateAdd function is fixed.
- Incorrect stored procedure naming when dropping it to design pane is fixed.
(if a procedure is in non-default schema, invalid query was generated)
- Exception on clicking on the datasource's link button on Design Pane is fixed.
- Binding of join lines on Design Pane to left or right side of DataSource
control is corrected.
- Displaying of field type size in DataSource control is corrected.
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!