Active Query Builder History v.2.13.2
+ The new QueryBuilder.MetadataLoadingOptions.AllowRecursiveVirtualObjects property has been made. Turning this option to True (default is False) lets interpret names found in SQL expressions of virtual objects as the names of other virtual objects. Note that this denies subsitution of real objects with same-named virtual objects. - The bug with the join context menu has been fixed. - The solution file of the Load Metadata Demo and some other demo projects has been corrected.
Active Query Builder History v.2.13.1
- The bug with searching in the Database Schema Tree has been fixed. + The new QB.Web.Application.TreeComponent.tooltipGetText method can be defined to set custom tooltip text for items in the Database Schema Tree. The Item object that is passed to this method has the following fields: caption (holds alternate name if UseAltNames is set to True), description, fullName, name, type (enum QB.Web.Enum.MetadataType), typeStr.
Active Query Builder History v.3.2.2.1035
+ IBM DB2: The ListAgg function is supported now. + Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields collections now include invalid objects and fields being used in the query. They differ from valid objects by the absence of MetadataObject (for objects) and MetadataField (for fields) references. - MS SQL Server: DATEPART parser ambiguity has been fixed.
Active Query Builder History v.3.2.2.1035
+ The new SubQueryBreadcrumbsBar control has been made. It makes quickly switch to parent sub-queries. + The new ActiveUnionSubQueryChanging event has been added to the QueryView and QueryBuilder components. It lets deny switching to another sub-query that might be helpful if you let end-users edit the text of sub-queries apart from the main query, in the case of the sub-query text parsing error. + The new SubQueryTextEditingDemo project has been added to Professional and Trial installation packages. + IBM DB2: The ListAgg function is supported now. + Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields collections now include invalid objects and fields being used in the query. They differ from valid objects by the absence of MetadataObject (for objects) and MetadataField (for fields) references. = The QueryStructureDemo has been refactored. - The bug with creating Link controllers has been fixed. - MS SQL Server: DATEPART parser ambiguity has been fixed. - Criteria Builder displays selected value in the format of the current culture. - The bug in the Navigation Bar controller has been fixed.
Active Query Builder History v.3.2.2.1035
+ The new SubQueryBreadcrumbsBar control has been made. It makes quickly switch to parent sub-queries. + The new ActiveUnionSubQueryChanging event has been added to the QueryView and QueryBuilder components. It lets deny switching to another sub-query that might be helpful if you let end-users edit the text of sub-queries apart from the main query, in the case of the sub-query text parsing error. + The new SubQueryTextEditingDemo project has been added to Professional and Trial installation packages. + IBM DB2: The ListAgg function is supported now. + Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields collections now include invalid objects and fields being used in the query. They differ from valid objects by the absence of MetadataObject (for objects) and MetadataField (for fields) references. = The QueryStructureDemo has been refactored. - The bug with creating Link controllers has been fixed. - MS SQL Server: DATEPART parser ambiguity has been fixed.
Active Query Builder History v.2.10.5.799
+ PostgreSQL: Support of materialized view, TOAST tables and foreign tables has been made. + Oracle: Support of the "AT TIME ZONE" clause has been added. + Firebird: Column name definition after alias in the FROM clause is supported now. + IBM DB2: The ListAgg function is supported now. + Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields collections now include invalid objects and fields being used in the query. They differ from valid objects by the absence of MetadataObject (for objects) and MetadataField (for fields) references. - Detection of recursion loops in virtual objects definition has been made. - Default UI culture is used to format values in Criteria Builder. - MySQL: Parsing of DATE, TIME, and DATETIME types as keywords has been fixed.
Active Query Builder History v.2.13.0
- The bug with datasouce popup menu not showing in IE has been fixed. + Ability to add new calculated fields by the end-user has been made. Now users can add new fields to database objects and specify custom SQL expressions for them. These can be fields intended to perform some manipulations on real database object fields (concatenation, "if - then" expressions, etc.) They can also be used to get values from lookup tables. Of course, the end-user must have the necessary knowledge of SQL language, so we recommend to turn this feature on only if you know that if will be valuable for your end-users. Setting the new QueryBuilderControl.EnableUserFields property to true enables addition and removal of user-defined fields by the end-user. + The new validateCondition and validateExpression methods have been added to validate values for the Expression and Condition grid cells. + The new MetadataContainer.ExportUserFieldsToXML and ImportUserFieldsFromXML methods have been added to save and restore user-defined fields to a file. They let keep the user's work between work sessions. + The new User Fields demo has been added to demonstrate the new functionality. + The new "AllColumns" value can be applied to the UseCustomExpressionBuilder property of the Grid control. Setting it turns the possibility to edit values in both Expression and Condition column cells using the custom editor. + The new method QB.Web.Application.setUserData(data) has been added. The data passed to this method will be sent to the server within the next sync event.
Active Query Builder History v.3.2.2.1034
+ The new SQLite metadata provider has been added. + PostgreSQL: Support of materialized view, TOAST tables and foreign tables has been made. + Oracle: Support of the "AT TIME ZONE" clause has been added. + Firebird: Column name definition after alias in the FROM clause is supported now. - The bug with loading of Query Transformer commands has been fixed. - MySQL: Parsing of DATE, TIME, and DATETIME types as keywords has been fixed.
Active Query Builder History v.3.2.2.1034
+ The new SQLite metadata provider has been added. + Usability of Expression Editor is improved now with the new dockable panels. + SQL Text Editor with syntax highlighting is used now to edit joining expression in the Properties bar and dialog. + Ability to deny switching to another sub-query has been made. It lets handle parsing errors while editing the text of sub-query apart from the main query. Handle the ActiveUnionSubQueryChanging event and set the e.Abort parameter to true to deny sub-query changing. + Now it's possible to select multiple rows and drag them to reorder columns in the SELECT list. + DevExpress: Query Columns Grid has been remade with DevExpress controls. + PostgreSQL: Support of materialized view, TOAST tables and foreign tables has been made. + Oracle: Support of the "AT TIME ZONE" clause has been added. + Firebird: Column name definition after alias in the FROM clause is supported now. - The bug with not saving the layout of objects after parsing of modified query has been fixed. - The bug with loading of Query Transformer commands has been fixed. - Minor fixes in the SQL Text Editor have been made. - Default UI culture is used to format values in Criteria Builder. - MySQL: Parsing of DATE, TIME, and DATETIME types as keywords has been fixed.
Active Query Builder History v.3.2.2.1034
+ The new SQLite metadata provider has been added. + Usability of Expression Editor is improved now with the new dockable panels. + SQL Text Editor with syntax highlighting is used now to edit joining expression in the Properties bar and dialog. + Ability to deny switching to another sub-query has been made. It lets handle parsing errors while editing the text of sub-query apart from the main query. Handle the ActiveUnionSubQueryChanging event and set the e.Abort parameter to true to deny sub-query changing. + Now it's possible to select multiple rows and drag them to reorder columns in the SELECT list. + The new Query Structure Demo has been made. + PostgreSQL: Support of materialized view, TOAST tables and foreign tables has been made. + Oracle: Support of the "AT TIME ZONE" clause has been added. + Firebird: Column name definition after alias in the FROM clause is supported now. - The bug with not saving the layout of objects after parsing of modified query has been fixed. - The bug with loading of Query Transformer commands has been fixed. - Minor fixes in the SQL Text Editor have been made. - MySQL: Parsing of DATE, TIME, and DATETIME types as keywords has been 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!