Downloads

Active Query Builder Java Edition History

June 08, 2011

Active Query Builder Java Edition v.1.4.1.1073

= Metadata loading is speeded up, memory usage is optimized.

May 23, 2011

Active Query Builder Java Edition v.1.4.0.1072

- MS SQL Server: Support of the DateAdd function is fixed.

May 20, 2011

Active Query Builder Java Edition v.1.4.0.1071

+ The new ActiveUnionSubQueryChanged event is added.
= MySQL Query Properties dialog is redesigned.
= The numbers entered into condition for string fields are treated as literals.
= Grouping is set automatically now on specifying the aggregate for a column.
= Automatic alias assignment is made when user adds two or more columns with 
  same name to the query. The warning message is shown when muptiple columns
  with same name appear in sub-queries in result of user actions as this may 
  lead to inconsistence in the calling sub-query.
- MS SQL Server: Fetching metadata object descriptions from database is made.
- Metadata refreshing for derived tables is fixed.
- Diagram pane was not scrolling when dragging a table. Fixed now.
- MySQL: The SQL_NO_CACHE option in MySQL Query Properties dialog is fixed.

May 16, 2011

Active Query Builder Java Edition v.1.3.4.1070

- Oracle: The TRANSLATE function and CAST-MULTISET-AS clause are fixed.

May 13, 2011

Active Query Builder Java Edition v.1.3.4.1069

- The bug with redundant WITH clause after removal of the last CTE is fixed.
- MySQL: The bug in SELECT INTO DUMPFILE option is fixed.
+ MySQL: The SELECT [DISTICTS|ALL] options are added to the query properties
  dialog.

May 11, 2011

Active Query Builder Java Edition v.1.3.4.1068

- The problem with cell editor remaining after deletion of a row is fixed.
- MySQL: The bug with expected closing bracked in "EXISTS (sub-select)" statement
  is fixed now.
- The bug with conditions containing OR in JOIN clause is fixed.

March 09, 2011

Active Query Builder Java Edition v.1.3.4.1067

- Fixed diagram pane background painting in Nimbus look'n'feel.
= Query Structure Tree now shows dervied table alias instead of sub-query text.

March 02, 2011

Active Query Builder Java Edition v.1.3.3.1066

- Hot fix for condition parsing.
- Query update after CTE changes is fixed.

February 24, 2011

Active Query Builder Java Edition v.1.3.3.1065

= Expression parsing is improved.
- MySQL: Missing bit operators are added.
- DB2: Missing Trim(), Position() and Extract() functions are added.
- DB2: Fixed some JOIN ambiguities.

February 18, 2011

Active Query Builder Java Edition v.1.3.2.1064

- Microsoft Access parser is fixed.
- getLayoutSQL()/setLayoutSQL methods are fixed.

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:

Tweets

Testimonials

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