Active Query Builder WinForms Edition 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.
Active Query Builder WinForms Edition 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.
Active Query Builder WinForms Edition 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.
Active Query Builder WinForms Edition 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.
Active Query Builder WinForms Edition v.1.15.4.320
- ExpressionEditor: The LoadFieldsOnSearching property did not interfere with fields loading on manual expansion of nodes.
Active Query Builder WinForms Edition v.1.15.4.319
- 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 6.4.3.0.
Active Query Builder WinForms Edition v.1.15.3.318
+ 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.
Active Query Builder WinForms Edition v.1.15.2.317
- The bug in ConvertDatasourceToDerivedTable() method is fixed. - Fixed problem with deletion of orphaned links.
Active Query Builder WinForms Edition v.1.15.2.316
+ The new UnionSubQuery.ConvertDatasourceToDerivedTable() method is added.
Active Query Builder WinForms Edition v.1.15.2.315
+ UnionSubQuery class is updated: Clear() method is added; SQL property { get; set } is added.
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!