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.
Active Query Builder Java Edition v.1.6.2.1130
- Oracle: Unnecessary brackets in WHERE in some queries are eliminated.
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.
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.
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.
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.
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.
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.
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.
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.
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!