Active Query Builder ActiveX Edition History

June 08, 2011

Active Query Builder ActiveX Edition v.1.17.1

+ MS SQL Server: Table and query hints are supported; join hints are parsed
  fine now, but not preserved due to architecture limitations.
- SQLite: Parsing of sub-queries in condition cells is fixed.
- German translation: Wrong translation "Default"->"German" is reverted to
= MySQL: UNSIGNED is treated as a valid data type now.

May 19, 2011

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.

May 04, 2011

Active Query Builder ActiveX Edition v.1.16.19

+ Automatic alias assignment is made when user adds two or more columns with 
  same name to the query. The warning message is shown when muptiple columns
  with same name appear in sub-queries in result of user actions as this may 
  lead to inconsistence in the calling sub-query.
- Minor bug fixes are made.

April 23, 2011

Active Query Builder ActiveX Edition v.1.16.18

+ SQLite: The component can load foreign keys now.
= SQLite: The list of aggregates and built-in functions is filled now.
= Preserving additional ORDER BY attributes like "ORDER SIBLINGS BY" is made.
= Turkish.lng: correct order of params in "Unexpected token" error message
- The component will not try to load fields from database now if they already
  loaded during execution of the ObjectMetadataLoading event handler.
- MS SQL Server: Support of the OPENQUERY function is fixed.
- Few CTE bugs are fixed.

April 13, 2011

Active Query Builder ActiveX Edition v.1.16.16

= Language files are converted to UTF8. The component allows to read language 
  files in both ANSI and UTF8 encoding now.
- Wrong SQL generation when object and database names are equal is fixed.
- The bug with using CustomExpressionEditorParams.CompletionsList is fixed.

April 06, 2011

Active Query Builder ActiveX Edition v.1.16.12

+ The new property IActiveQueryBuilderX.SQLFormatCTE is made to define formatting
  rules of CTE sub-queries independently from derived tables.
- Better parsing of criteria expressions is made.

March 23, 2011

Active Query Builder ActiveX Edition v.1.16.11

= Custom caption in EditProperties2 is not ignored now.
+ OLE drag-and-drop of text items to design area and criteria grid is made.
+ The new properties are added to allow OLE drag'n'drop of text items to the
  Design Area (QueryBuilder.OLEDragAndDrop: Boolean) and the Query Colums Grid
  (QueryBuilder.SelectListOptions.OLEDragAndDrop: Boolean).
+ The new AParam.CompletionsList property in OnCustomExpressionBuilder event is
  added to get access to the list of datasource columns of the currently active
= MySQL: more accurate checking of the current database request is made.
- Oracle: correct printing of objects with @DBLINK is made.
- Replacing name of stored proc with it's alias is fixed.

March 02, 2011

Active Query Builder ActiveX Edition v.1.16.8

- The bug with entering criteria prefixed with comparison operators is fixed.
  (introduced in 1.16.6)
= DB2: Additional aggregate functions are added: VAR_POP, VAR_SAMP
= Fixed bug with incorrect removal of selected query fields not related to the
  sub-query on removing same named fields from the sub-query.

February 24, 2011

Active Query Builder ActiveX Edition v.1.16.6

+ The new properties are added to get access to the active sub-query text:
  ActiveSubQuerySQL and ActiveUnionSubQuerySQL.
- The position parameter in the OnCustomExpressionBuilder event now measured
  from the top-left corner of the component (was of the columns grid control).
- Add Object Form: The ListView display mode is now applied correctly.
+ Add Object Form: Descriptions for metadata objects are displayed now in the
  Report ListView mode.
= MySQL: The || and && operators are treated now correctly according to the
  server configuration (as synonyms for logical OR and AND in default mode).
+ IBM DB2: Statistics aggregate functions are added.
+ IBM DB2: Extended syntax for TRIM, POSITION and EXTRACT functions, string
  types with CCSIDs are supported now.
= The "{expression}" entered to the Condition cell is converted to 
  "= {expression}" now.
+ MySQL: &,|,^,<<,>> operators are supported now.
- CAB signing is fixed.

February 09, 2011

Active Query Builder ActiveX Edition v.1.16.4

- DB2: The INNER, LEFT and RIGHT join keyword parser ambiguities are removed.
- ObjectMetadataLoading and ObjectMetadataLoaded events were not fired 
  in offline mode. Fixed now.

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