Active Query Builder WinForms .NET Edition 2.10 is released.
We're glad to announce the new version of Active Query Builder 2 .NET Edition. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.
What's new in the Active Query Builder .NET Edition version 2.10?
Major improvements:
Support for Netezza SQL syntax is added.
Support for Advantage Database Server syntax is added.
Metadata provider for VistaDB 5 database engine is added.
DevExpress UI: Context menus in all components are skinned now.
Minor improvements and API changes:
API change: Signature of the ValidateContextMenu event delegate is changed. See the updated Events Demo for menu modification example.
The new MetadataContainer.Clear() method is added.
New overload is added for the ShowAddObjectForm() method with the MetadataStructure parameter allowing to customize metadata representation in the form.
The new QueryColumnListOptions.CreateColumnAliasesForUnnamedColumns property is added to instruct the component to add aliases for unnamed fields (expressions, aggregates) automatically. It's turned on by default.
The new events are added to track user search actions in the Database Schema Tree: QueryBuilder.BeforeQuickSearchStarted and QueryBuilder.QuickSearchFinished. The first event allows to cancel search action, the second event provides the number of found items.
SQL Text Editor: The new properties are added to allow changing colors of gutter area: GutterForeColor, GutterBackColor, GutterSeparatorColor.
Query Transformer: The new AlwaysWrapInSubQuery property prescribes to wrap user query in a sub-query in any case.
The new MetadataStructureChanged event is added. It is fired on changing the value of MetadataStructure property. This happens automatically on turning the Database Schema Tree to display search results and back.
SQL syntax improvements and changes:
SQLite: Support for Common Table Expressions (CTE) is made.
MS SQL Azure: Metadata loading is improved.
Teradata: Loading of foreign keys is fixed.
Oracle: Parsing of the "REFERENCE" keyword is fixed.
PostgreSQL: Parsing of ANY, SOME, ALL predicates is fixed.
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!