Active Query Builder ActiveX Edition v.1.17.6
+ The check box is added to the Grouping column header. It allows to quckly toggle the grouping for the query on and off. - Adding objects with same AltName from the database objects tree is fixed.
Active Query Builder ActiveX Edition v.1.17.5
+ The check box is added to the Grouping column header. It allows to quckly toggle the grouping for the query on and off. - MySQL: Reversed displaying of foreign key relationships is fixed. - Exception is not raised now if the OleInitialize call is failed. It's necessary for OLE drag'n'drop functionality. - PostgreSQL: Parsing of SUBSTRING function and ARRAY literals is made.
Active Query Builder ActiveX Edition v.1.17.3
- Minor bugfixes are made.
Active Query Builder ActiveX Edition v.1.17.2
= MS SQL: Loading objects from linked servers is restored. = MySQL: Parsing of the ORDER BY clause is improved. - Mimer Sql: Reference type is not supported by MimerSql. Fixed now. - AV on creating link by identical field names is fixed.
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 "Default". = MySQL: UNSIGNED is treated as a valid data type now.
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.
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.
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.
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.
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.
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!