Active Query Builder WinForms Edition v.1.19.0.424
= DevExpress references are updated to v.12.2.9.0. - Teradata query properties form is fixed.
Active Query Builder WinForms Edition v.1.19.0.422
+ The new QueryTransformer component is added. It is intended to easily modify SQL query sorting, filtration and aggregation programmatically. See the "QueryTransformerDemo" source code sample.
Active Query Builder WinForms Edition v.1.18.3.420
= Internal change: Binding column names is not performed now if fieldless datasources are in the scope.
Active Query Builder WinForms Edition v.1.18.3.418
+ The new MetadataContainer.ConnectionIdle event is added. It allows for closing the database connection if it's not desirable to keep it open during the work session.
Active Query Builder WinForms Edition v.1.18.2.417
+ SQL Text Editor and Expression Editor: The new properties are added to
improve usability of the code completion feature and to prioritize the
content of suggestion lists:
* The ShowSuggestionAfterCharCount property determines number of chars
that should be typed before the suggestion list will popup;
* The SuggestionListContent property allows to filter the content of
suggestion list (keywords, SQL functions and metadata objects);
* The KeepMetadataObjectsOnTopOfSuggestionList property being set to True
instructs to act exactly what is written.
= SQL Text Editor: Background processing is reworked to the Single Thread
Apartment (STA) model to eliminate problems with drag and drop registration
in parent application.
Active Query Builder WinForms Edition v.1.18.1.415
- The problem with incorrect aliases in ORDER BY in some cases is fixed. - SQL Text Editor: The REGEXP_LIKE function is added to the suggestion list.
Active Query Builder WinForms Edition v.1.18.1.414
- Processing of the prefix character (&) is turned off when drawing field names and descriptions in design pane datasource object. - DevExpress: Painting of empty parentheses in field descriptions in datasource objects on design pane is turned off. - Oracle: Support for REGEXP_LIKE function is added. - DB2 and Oracle: Duplication of the TABLE wrapper for stored procedures in FROM clause is fixed. - Incorrect grouping on assigning sort order for aggregated expressions is fixed.
Active Query Builder WinForms Edition v.1.18.1.412
+ SQL Text Editor and Expression Editor: The WordWrap property is added. + SQL Text Editor: Performance is improved. = Aliases are emitted instead of expressions in the Order By clause when possible. - MS Access: Support for TRIM builtin function is made. - Incorrect loading of some complex conditions is fixed. - DevExpressControlFactory assembly loading when used from Excel-DNA is fixed.
Active Query Builder WinForms Edition v.1.18.0.411
- Fixed controls layout in LinkPropertiesForm for proper look at 120DPI.
Active Query Builder WinForms Edition v.1.18.0.409
= French localization is updated (Thanks to Nicolas LECOINTRE). - Oracle: Support for CONNECT_BY_ROOT clause is added. - Oracle: Order of START WITH and CONNECT BY clauses 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!