Active Query Builder History v.1.5.5.1110
= Performance optimizations are made. = QueryStatistics.OutputColumns.ColumnName property returns unquoted name now. - Setting the QuoteAllIdentifiers and ObjectPrefixSkipping properties does not clear the query any more. - Fixed double space character before unary operators. - Fixed problem with recursive CTE. - MySQL: Fixed parsing of logical expressions in criteria cells. - Oracle: Fixed parsing of TABLE function. - Oracle: Fixed parsing of expressions like "Expression IN Expression". - Oracle: Removed the NESTED flag from multiline comments.
Active Query Builder History v.1.16.6.356
- Unnamed query parameters order is fixed. = DevExpress dependencies of DevExpressControlFactory are updated to v.11.2.10.0.
Active Query Builder History v.1.16.6.355
- SQL Text Editor: The suggestion window did not hide on focus lost. Fixed now. The new HideSuggestionWindow() method is added for it's manual hiding. = More performance optimizations are made.
Active Query Builder History v.1.16.6.354
= Performance optimizations are made. = More informative XML parsing exceptions (the inner exception is correctlty passed to AstException wrapper). - SQL Text Editor: Wrong tooltip height when the control is hosted in WPF WindowsFormsHost is fixed. - The problem with recursive CTE is fixed. - Oracle: Parsing of expressions like "expression IN expression" is fixed. - Oracle: Nested multiline comments were affecting the parsing. Fixed now.
Active Query Builder History v.0.5.13
+ The new ObjectTree.SortingType property is added to sort objects in the tree. + The new QueryBuilderControl.MultipleQueriesPerSession property is added to allow building of multiple queries in separate browser windows.
Active Query Builder History v.1.16.5.353
+ SQL Text Editor: Text drag and drop is implemened. + SQL Text Editor: The new events are added: PreProcessKey, PostProcessKey, PreProcessMouseDown, PreProcessMouseMove, PreProcessMouseUp.
Active Query Builder History v.1.5.4.1109
+ The new ComponentCreated and ComponentDestroying events notifying about query UI components created and destroying are added. = Sub-query tab captions display sub-query alias instead of query text now.
Active Query Builder History v.1.16.4.352
- SQL Text Editor: The exception on showing Find dialog when the control is hosted in WPF window is fixed.
Active Query Builder History v.1.16.4.351
- Oracle: Parsing of TABLE function is fixed. - MySQL: Parsing of logical expressions in criteria cells is fixed. - Changing of the QuoteAllIdentifiers and ObjectPrefixSkipping properties does not clear the query any more. = QueryStatistics.OutputColumns[i].ColumnName is always unquoted now.
Active Query Builder History v.1.16.4.350
- DevExpressControlFactory: The CriteriaListOptions.CriteriaListFont property did not affect the DevExpressCriteriaListControl font. Fixed now. - DevExpressControlFactory: Automatic alias generation when adding fields with same names is fixed.
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!