Active Query Builder History v.1.3.4.1069
- The bug with redundant WITH clause after removal of the last CTE is fixed. - MySQL: The bug in SELECT INTO DUMPFILE option is fixed. + MySQL: The SELECT [DISTICTS|ALL] options are added to the query properties dialog.
Active Query Builder History v.1.14.11.302
- The multi-threading synchronization issue is fixed. - The bug with redundant WITH clause after removal of the last CTE is fixed. - MySQL: The bug with SELECT INTO DUMPFILE option is fixed. + MySQL: The SELECT [DISTICT|ALL] options are added to the query properties dialog.
Active Query Builder History v.1.14.11.301
+ Added new API method UnionSubQuery.AddLinksFromExpression() for manual adding of links with complex joining expressions. - Fixed problem when a link was attached to wrong datasource on the design pane in some rare conditions. - PostgreSQL: Parsing of logical expressions in criteria cells is fixed.
Active Query Builder History v.1.16.22
= Support of DevExpress ver.56 is made. (Package name renamings were made) + The new method TacUnionSubQuery.AddLinksFromExpression() is added for manual adding of links with complex joining expressions. - Fixed problem when a link was attached to wrong datasource on the design pane in some rare conditions. + Metadata fetching support for NexusDB 3 is made. - PostgreSQL: Parsing of logical expressions in criteria cells is fixed. - Localizer: Loading of milti-line translated strings is fixed. = Oracle: The GetSchemasListOracle procedure returns only schemas which have accessible database objects now. = The Select checkbox is checked automatically now on adding a new expression.
Active Query Builder History v.1.3.4.1068
- The problem with cell editor remaining after deletion of a row is fixed. - MySQL: The bug with expected closing bracked in "EXISTS (sub-select)" statement is fixed now. - The bug with conditions containing OR in JOIN clause is fixed.
Active Query Builder History v.1.14.11.299
+ 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. + The new UserMessage event is added. It is fired when the Query Builder is about to show the warning message to the user. You may override this behavior by handling the UserMessage event.
Active Query Builder History 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. + The new OnUserMessage event is added. It is fired when the Query Builder is about to show the warning message to the user. You may override this behavior by handling the OnUserMessage event. = The CreateWhereJoinsByDefault property is moved to QueryBuilder.LinkOptions. = The AddObjectWithFK method takes into account the CreateLinksByIdenticalFields property value now. = C++ Builder 6 support is reverted. - Minor bug fixes are made.
Active Query Builder History 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 History v.1.14.10.298
- The bug with editing GROUP BY in query without a GROUP BY clause is fixed.
Active Query Builder History v.1.14.10.297
+ The new LinkOptions.CreateLinksByIdenticalFieldNames property is added. It instructs the component to add links between objects by identical field names (might be useful for legacy databases without foreign keys). + SQLite: The component can load foreign keys now. = SQLite: The list of aggregates and built-in functions is filled now. + SQL text formatting options for CTE sub-queries are made (PlainTextSQLBuilder.CTESubQueryFormat). = DevExpressControlFactory dependencies are updated to v.10.2.7.0. - The bug with adding derived table or CTE into the same CTE is fixed. - The bug with generating invalid SQL if object and database names are equal is fixed. - MS SQL Server: Support of the OPENQUERY function is fixed. - Oracle: The bug with removing references to datasources from the CONNECT BY clause is fixed.
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!