Downloads  »  Active Query Builder ActiveX Edition History

May 19, 2011

Active Query Builder ActiveX Edition v.1.17.0

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.

» Full Active Query Builder ActiveX Edition history

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:



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