Active Query Builder Java Edition v.1.2.17.1048
= Visual tweaks for CTE tabs are made. - Sybase: Union operators list is fixed. - Oracle: Problem with recursive CTE is fixed. - Oracle: Support of materialized views is added.
Active Query Builder Java Edition v.1.2.16.1046
+ Now it's possible to remove CTE from the query using the Close button at the tab.
Active Query Builder Java Edition v.1.2.15.1044
+ GetDiagramObjectWidth event is added. It allows you to implement automatic diagram objects width changing (e.g. to fit the title text). = Algorithm of automatic objects placement on the diagram pane is improved. - Explicit font setting is removed from all dialogs to make them compatible with non-Latin character languages. - Bug with removing of multiple sub-queries from criteria field is fixed.
Active Query Builder Java Edition v.1.2.14.1043
- Oracle: DBLinks syntax is fixed. - Oracle: List of aggregates is fixed. - Sort Order column content is fixed. - Fixed exception when deleting a criteria list row with two or more condition columns containing a subquery.
Active Query Builder Java Edition v.1.2.14.1041
= Oracle: Loading of metadata relations is optimized. - Oracle: Support for CURSOR() expressions is added. - Identifier "Table" is now quoted where necessary. - Fixed bug with last used schema in AddObjectDialog. - UnionNavBar: tooltip over the union symbol now shows correct value. - UnionNavBar: "Enclose with brackets", "Move right" and "Move left" commands do not reset preceding union operators. = UnionNavBar: Empty brackets now will be removed automatically. - UniversalSyntaxProvider: Missing standard builtin functions are added. - Fixed problem with isSupportNullOrdering() in AutoSyntaxProvider.
Active Query Builder Java Edition v.1.2.13.1040
+ get/setCustomDiagramPaneDropTarget() and get/setCustomCriteriaListDropTarget() methods are added to the QueryBuilder. Use them to set custom DropTarget objects for the Diagram Pane and Criteria List controls and override default drag and drop behaviour. Since DropTarget object can be bound to a single component only, you should pass different instances of your DropTarget implementations to those methods. - Fixed bug with "$" sign in Access syntax.
Active Query Builder Java Edition v.1.2.12.1038
+ Added support for Ingres database server. Use it with UniversalSyntaxProvider. = Default "SELECT * FROM" statement is removed. + QueryBuilder.CriteriaListOptions.setCriteriaListHeaderFont() method is added.
Active Query Builder Java Edition v.1.2.9.1033
+ Signed version of ActiveQueryBuilder.jar is added. Use it with applets to avoid security warnings and restrictions. = ActiveQueryBuilder.jar now contains no classes in the default package. - Query Builder was unable to load table fields from MSSQL because it supports the cursor holdability on the connection level only. Fixed now.
Active Query Builder Java Edition v.1.2.8.1030
- DB2: Loading of complex WITH queries is fixed.
Active Query Builder Java Edition v.1.2.8.1029
+ FairCom C-Tree SQL server is supported now. Use it with the SQL92SyntaxProvider or the UniversalSyntaxProvider. - MS Access table fields fetching 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!