Downloads

Active Query Builder Java Edition History

July 31, 2013

Active Query Builder Java Edition v.1.6.3.1131

= Mixed-case alternate names now treated as mixed-case identifiers and quoted
  according to the server case sensitivity rules.
= MS SQL Server: Table hints syntax is updated according to the SQL Server 2012.
- MS Access: Assertion failure on clearing a complex query is fixed.

July 08, 2013

Active Query Builder Java Edition v.1.6.2.1130

- Oracle: Unnecessary brackets in WHERE in some queries are eliminated.

May 08, 2013

Active Query Builder Java Edition v.1.6.2.1129

- Oracle: Support for REGEXP_LIKE function is added.
- DB2 and Oracle: Duplication of the TABLE wrapper for stored procedures in 
  FROM clause is fixed.

April 18, 2013

Active Query Builder Java Edition v.1.6.2.1128

- MS SQL Server: Connection failure caused by Microsoft JDBC driver that 
  doesn't support sql_variant data type.
- PostgreSQL: Fields case is preserved now on visual link creation.
- MS Access: Support for TRIM builtin function is added.
= ANSI SQL/89, SQL/92 and SQL/2003 syntax providers: New setters are added to
  adjust to server capabilities: setSupportDatabases() and setSupportSchemas().
- Incorrect loading of some complex conditions is fixed.
= Aliases are emitted in the Order By clause when possible.
= French localization is updated.

March 12, 2013

Active Query Builder Java Edition v.1.6.1.1127

+ The new getters are added to the StatisticsOutputColumn class: 
  getDataSource, getObjectNameInQuery, getColumnNameInQuery.
- Oracle: Support for CONNECT_BY_ROOT clause is added. 
- Oracle: The order of START WITH and CONNECT BY clauses after parsing is fixed.
- Oracle: Ambiguity in parsing of qualified column name with method call is 
  resolved.

March 01, 2013

Active Query Builder Java Edition v.1.6.0.1126

- Oracle: Support for named parameters in function call is added.
- PostgreSQL: The bug with quoting some date time and system functions like
  CURRENT_DATE or USER when QuoteAllIdentifiers property is set to true is fixed.

February 20, 2013

Active Query Builder Java Edition v.1.5.8.1125

+ The new syntax provider for Teradata database server is made. Use the
  TeradataSyntaxProvider for the complete support of Teradata SQL syntax.
- Oracle: Support for method call expressions is made.

January 29, 2013

Active Query Builder Java Edition v.1.5.7.1124

- QueryBuilder was unable to load foreign keys from database connection if used
  with SQL92SyntaxProvider or SQL2003SyntaxProvider. Fixed now.

January 15, 2013

Active Query Builder Java Edition v.1.5.7.1123

- Oracle: Support for KEEP expression is added.
- Oracle: Parsing of CONNECT BY expression is fixed.
- Sybase: Parsing of START AT clause is fixed.

November 01, 2012

Active Query Builder Java Edition v.1.5.7.1122

= The column header containing a checkbox is now painted according the current
  look and feel.
- Oracle: The MODEL clause is fixed.
+ MS SQL Server: Support for "varchar(max)" is made.
- MS SQL Server: Redundant ":"-prefixed query parameters are removed.
- MS SQL Server: Tilda (~) is removed from th list of valid characters for
  identifiers.

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:

News

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