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