Active Query Builder Java Edition v.1.7.1.1140
- Oracle: Support for interval expressions is added. - DB2: Using short object names if SYSTEM naming convention is used.
Active Query Builder Java Edition v.1.7.1.1139
- Exception on closing a data source is fixed. = Appearance of multi-links in the Add Linked Objects menu is fixed.
Active Query Builder Java Edition v.1.7.1.1138
+ The Add Linked Objects menu now has separate items for each link if there are multiple links to the linked object. - MS SQL Server: Parsing of method calls is fixed.
Active Query Builder Java Edition v.1.7.0.1137
= The new AltNameCaseSensitive flag is added to all objects with Alt. names.
Active Query Builder Java Edition v.1.7.0.1136
- The bug with improper column names at visual link creation is fixed.
Active Query Builder Java Edition v.1.7.0.1135
- DB2: Loading of foreign keys is fixed.
Active Query Builder Java Edition v.1.7.0.1134
+ The new button is now shown at the right of the focused datasource on Design pane to allow easy adding of linked objects to the query. The feature is also available from the datasource context menu. + The new ShowLinkedObjectsButton property is addeed. - Auto-detection of Teradata and SQL CE servers is fixed. - Loading of WHERE joins with subqueries referencing other datasources is fixed. - PostgreSQL: Support for AT TIME ZONE expression, ROW constructor expression, and ORDER BY in aggregate functions is fixed. - MS SQL Server: "PARSE" is a valid identifier now. - MS SQL Server: The conflict between "char" and "nchar" identifiers and same-named built-in functions is eliminated. = MS SQL Server: Parsing of nested function calls is speeded up.
Active Query Builder Java Edition v.1.6.4.1133
+ Now the Query Builder keeps layout of design pane objects after manual changes of the query text. - Incorrect bracketing of inner OR in some cases is fixed. - Oracle: Fixed parsing of PARTITON with OUTER JOIN. - Oracle: Fixed support for unicode literals (N'abcdef'). - Oracle: Fixed parsing of DENSE_RANK() function. - MSSQL: Added support for CLR method calls. - MSSQL: Improved the query for loading foreign keys from server. - PostgreSQL: Added support for multi-parameter aggregates. - PostgreSQL: Fixed parsing of ANY in codition cells.
Active Query Builder Java Edition v.1.6.3.1132
- Oracle: The "TIMESTAMP" identifier used as column name is allowed now.
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 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!