Below is the list of fixes and improvements in Active Query Builder ActiveX Edition v.1.17.0.
+ The new properties are added to the LinkOptions group: CreateLinksByIdenticalFieldNames and CreateWhereJoinsByDefault. The first one is intended to instruct the component to add links between objects by identical field names (might be useful for legacy databases without foreign keys). The second one instructs the component to create joins in WHERE clause, not using the JOIN keyword in FROM clause. Useful for Oracle databases when you want to use Oracle style joins (+=, =+). + SQL queries that look like "select orders.orderId from orders o" are fixed now to "select o.orderId from orders o". = Grouping is set automatically now on specifying the aggregate for a column. = The "=TRUE" condition is set automatically on adding a logical expression now. = The numbers entered into condition for string fields are treated as literals. = MySQL Query Properties form is redesigned. + MySQL: The [Default|DISTICTS|ALL] query options are added to the Query Properties dialog. - MS SQL Server: Fetching metadata object descriptions from database is made. - Metadata refreshing for derived tables is fixed. - Oracle: The TRANSLATE function and CAST-MULTISET-AS clause are fixed. - Minor bugs on reomving CTE from query are fixed.
[ Legend: ] [ + New feature ] [ = Improved/changed feature ] [ - Bug fix ] [ ! Important notice ]
You can always get the latest trial version of Active Query Builder ActiveX Edition at the download page.
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!