Active Query Builder Java Edition History

November 10, 2010

Active Query Builder Java Edition v.

+ Now it's possible to remove CTE from the query using the Close button at the 

November 03, 2010

Active Query Builder Java Edition v.

+ 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.

October 28, 2010

Active Query Builder Java Edition v.

- 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.

October 22, 2010

Active Query Builder Java Edition v.

= 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.

September 15, 2010

Active Query Builder Java Edition v.

+ 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.

September 07, 2010

Active Query Builder Java Edition v.

+ Added support for Ingres database server. Use it with UniversalSyntaxProvider.
= Default "SELECT * FROM" statement is removed.
+ QueryBuilder.CriteriaListOptions.setCriteriaListHeaderFont() method is added.

July 21, 2010

Active Query Builder Java Edition v.

+ 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.

July 06, 2010

Active Query Builder Java Edition v.

- DB2: Loading of complex WITH queries is fixed.

May 12, 2010

Active Query Builder Java Edition v.

+ FairCom C-Tree SQL server is supported now. Use it with the SQL92SyntaxProvider 
  or the UniversalSyntaxProvider.
- MS Access table fields fetching is fixed.

April 27, 2010

Active Query Builder Java Edition v.

- Assertion error if using an alias the same as the object name ("SELECT * FROM
  Orders Orders") is fixed.
- Fields with same names but from different tables were identified incorrectly
  in some cases. Fixed now.
- Option that hides global asterisk item "*" does not hide "Table.*" items. 
  Fixed now.

Product Summary

 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!

Social networks