Active Query Builder History v.3.3.9.1056
+ The new events are added to track addition and removal of items in the Query Columns List. QueryColumnListControl: ItemAdded and ItemRemoving; QueryBuilder: QueryColumnListItemAdded, QueryColumnsListItemRemoving. - Commands for adding and managing sub-queries in expressions are moved to the context menu of appropriate cells. The ellipsis button now immediately displays the Expression Editor. - IBM DB2: Database objects are now loaded from the server if loading from driver fails.
Active Query Builder History v.3.3.9.1056
+ The new events are added to track addition and removal of items in the Query Columns List. QueryColumnListControl: ItemAdded and ItemRemoving; QueryBuilder: QueryColumnListItemAdded, QueryColumnsListItemRemoving. - Commands for adding and managing sub-queries in expressions are moved to the context menu of appropriate cells. The ellipsis button now immediately displays the Expression Editor. - IBM DB2: Database objects are now loaded from the server if loading from driver fails.
Active Query Builder History v.3.3.8.1055
+ Database connection logging is possible now. - The critical bug with loading of top-level AND conditions has been fixed. - MS SQL Server: Object name is now used as default alias for objects from linked servers. - The MetadataStructureItem.GetDisplayCaption method has been speeded up.
Active Query Builder History v.3.3.8.1055
- The critical bug with loading of top-level AND conditions has been fixed. + The new DisableQueryNavigationBarPopup property has been added to the QueryBuilder.PanesConfigurationOptions group. + The new IDatabaseSchemaView.SQLGenerationOptions property has been added to alter displaying of object names in the tree. + Database connection logging is possible now. - Hiding of columns in the Query Transformer hadn't get applied immediately. Fixed now. - MS SQL Server: Object name is now used as default alias for objects from linked servers. - The MetadataStructureItem.GetDisplayCaption method has been speeded up.
Active Query Builder History v.3.3.8.1055
- The critical bug with loading of top-level AND conditions has been fixed. + The new DisableQueryNavigationBarPopup property has been added to the QueryBuilder.PanesConfigurationOptions group. + The new IDatabaseSchemaView.SQLGenerationOptions property has been added to alter displaying of object names in the tree. + Database connection logging is possible now. - Hiding of columns in the Query Transformer hadn't get applied immediately. Fixed now. - MS SQL Server: Object name is now used as default alias for objects from linked servers. - The MetadataStructureItem.GetDisplayCaption method has been speeded up. - Right clicking on the design pane hadn't displayed the menu. Fixed now.
Active Query Builder History v.3.3.7.1054
- IBM DB2: The method to retrieve the list of schemas now falls back to SQL query if loading from driver returns no schemas.
Active Query Builder History v.3.3.7.1054
= Conditions for the same left part joined using the OR operator are merged into a single cell now. - IBM DB2: The method to retrieve the list of schemas now falls back to SQL query if loading from driver returns no schemas. - Referencing objects for User Queries aren't loaded now.
Active Query Builder History v.3.3.7.1054
= Conditions for the same left part joined using the OR operator are merged into a single cell now. = "OR" condition columns in the Query Column List control are created on demand now. - IBM DB2: The method to retrieve the list of schemas now falls back to SQL query if loading from driver returns no schemas. - Referencing objects for User Queries aren't loaded now.
Active Query Builder History v.2.13.10
= The "object.*" item is added now to the query on dropping an object to the Query Columns Grid. - The bug with an object added to the query twice on dropping it between the Design Pane and the Query Columns Grid has been fixed. - The bug with incorrect displaying of fields in the search results in the Database Schema Tree has been fixed, - A memory leak on the client has been eliminated.
Active Query Builder History v.1.27.0
+ MySQL: Support of MATCH full-text search operator has been added. = DB2: The list of available databases is taken from the driver now. (OLE DB or ODBC). - DB2: The bug with selecting table owner instead of table schema for schema name has been fixed. - Access violation on removing active CTE has been eliminated.
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!