Active Query Builder History v.1.23.0
+ Asyncronous metadata loading support is made. + MS SQL Server: MS SQL Server 2014 is supported. - MS SQL Server: method call chain parsing is fixed. = MS SQL Server: keywords list is updated. + PostgreSQL: WITH clause support is made. = PostgreSQL: The "LIMIT 0" constraint is used for queries to fetch object columns (formerly used "LIMIT 1"). + Oracle: Parsing DATE, TIME and TIMESTAMP literals is fixed. + Oracle: Interval expressions are supported now. = DB2, MySQL, PostgreSQL, ANSI SQL: DATE, TIME and TIMESTAMP literals are supported now. = DB2: Short object names are used in case of SYSTEM naming convention. - MySQL: DATE and TIME types parsing ambuiguities fixed.
Active Query Builder History v.1.23.0
+ RAD Studio XE6 support is added. + Connection cloning and asyncronous SQL execution is possible now. + Asyncronous metadata loading support is made. + MS SQL Server: MS SQL Server 2014 is supported. - MS SQL Server: method call chain parsing is fixed. = MS SQL Server: keywords list is updated. + PostgreSQL: WITH clause support is made. = PostgreSQL: The "LIMIT 0" constraint is used for queries to fetch object columns (formerly used "LIMIT 1"). + Oracle: Parsing DATE, TIME and TIMESTAMP literals is fixed. + Oracle: Interval expressions are supported now. = DB2, MySQL, PostgreSQL, ANSI SQL: DATE, TIME and TIMESTAMP literals are supported now. = DB2: Short object names are used in case of SYSTEM naming convention. - MySQL: DATE and TIME types parsing ambuiguities fixed.
Active Query Builder History v.2.3.0
+ Keyboard navigation over the web controls is possible now. To turn on, link the "accessibility.css" and "accessibility.js" files from the "web-parts" folder to your web page. Use the "1" to "5" keys to switch between main parts of the component: database schema tree, sub-query navigation bar, design pane, query columns grid and query text editor. Use Tab and Shift-Tab keys to navigate over the controls. Use Enter to step into the sub-items of complex controls: datasource field lists, and cells of the query columns grid. + Accessibility demo is added. - CSS compatibility with jQueryUI themes is improved.
Active Query Builder History v.2.8.0.649
+ It is now possible to set different color for focused links using the QueryBuilder.DesignPaneOptions.LinkStyle.LinkColorFocused property. = Virtual objects now obey UseAltNames property on virtual fields expansion phase. = The source code of Query Modification Demo project is refactored.
Active Query Builder History v.2.2.8
- The Client Events Handling demo project is fixed. - Drag'n'drop from the structure tree is improved - Reconnect mechanism in the MultipleQueriesPerSession mode is improved. = ActiveDatabaseSoftware.ActiveQueryBuilder2.dll is updated to v.2.8.0.647.
Active Query Builder History v.2.8.0.647
+ Support for MS SQL Server 2014 is added. + The tool to conver metadata XML from the old v.1.x format to new is available as .NET assembly ActiveDatabaseSoftware.MetadataXmlConverter.dll. + Quick Search in the Database Schema Tree is now able to search by field names. Use the new property DatabaseSchemaTreeOptions.SearchFields to enable this feature. = Database Schema Tree now emphasizes the search string with underscore. - Add Object Form: The Enter key press response in the object list is fixed. - DevExpress Controls Factory: Non-default tree sorting modes are fixed. - OLE DB Metadata Provider: MetadataField.FieldType loading is fixed. - MS SQL Server syntax: Parsing of method call chain is fixed. - MySQL: DATE and TIME types parsing ambuiguities are eliminated. - DB2, MySQL, PostgreSQL and ANSI SQL standards: DATE, TIME and TIMESTAMP literals are supported now.
Active Query Builder History v.2.2.7
- The bug with updating joins is fixed. + ActiveDatabaseSoftware.ActiveQueryBuilder.MetadataXmlConverter.dll is added to let programmatic conversion of old v.1.x metadata XML schema to the new format.
Active Query Builder History v.2.7.5.645
+ The new BehaviorOptions.NotifyOnLinksCreatedAutomatically property is added to let track addition of automatically created links (by foreign keys or by identical field names) using the LinkCreated event.
Active Query Builder History v.2.7.4.644
- OLE DB Metadata Provider: Incorrect column order when loading metadata from Excel file via Microsoft ACE 12.0 OLE DB Provider is fixed. = Documentation is updated.
Active Query Builder History v.2.2.6
= Diagram links drawing is improved. - Minor GUI bug 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!