Active Query Builder 2 WinForms Edition v.2.9.1.694
+ The new MetadataStructureChanged event is added. It is fired on changing the value of MetadataStructure property. This happens automatically on turning the Database Schema Tree to display search results and back.
Active Query Builder 2 WinForms Edition v.2.9.1.693
- Null Reference Exception that was raised with some databases using the "Type, Name (Except Fields)" sorting mode in the tree is eliminated. = Query Transformer and Criteria Builder: The new OutputColumn.DataType property is added to adjust the column datatype to change the editor type in Criteria Builder for this column.
Active Query Builder 2 WinForms Edition v.2.9.1.692
- CriteriaBuilder: AutoSize and Anchor properties conflict is resolved. - DevExpress: List sorting in the AddObjectForm is fixed. + The new MetadataContainer.Clear() method is added.
Active Query Builder 2 WinForms Edition v.2.9.1.691
+ New overload is added for the ShowAddObjectForm() method with the MetadataStructure parameter allowing to customize metadata representation in the form. + The new QueryColumnListOptions.CreateColumnAliasesForUnnamedColumns property is added to instruct the component to add aliases for unnamed fields (expressions, aggregates) automatically. It's turned on by default. + SQLite: Support for Common Table Expressions (CTE) is made. - SQLite: Support for backtick-quoted identifiers is made. - Firebird: Support for the WEEK date part is added. - MySQL: Support for quoted characters in string literals is made.
Active Query Builder 2 WinForms Edition v.2.9.0.690
- The bug with hanging on foreign keys loading being connected through the ADO.NET provider which uses non-standart schema column names (like Devart.Data.Oracle provider) is fixed.
Active Query Builder 2 WinForms Edition v.2.9.0.689
= DevExpress references are updated to v.14.1.7.0. - Build error is fixed in the Events Demo project. - Values for the MetadataField.Size received from server are preferred compared with those obtained from ADO.NET provider. - MS SQL Server: The DetectServerVersion method isn't called now if MetadataProvider.Connection is null. - Linked Objects menu: Links for foreign keys by multiple fields are created correctly now (they were created by the first field only).
Active Query Builder 2 WinForms Edition v.2.9.0.687
- The bug on calling the QueryBuilder.Clear() in non-visual mode is fixed. - DevExpress: Sorting in the Database Schema Tree is fixed. - Query Transformer: The problem with duplicated column names is fixed.
Active Query Builder 2 WinForms Edition v.2.9.0.685
= Oracle: Expression parsing performance is improved. - The bug with incorrect column prefix for virtual objects in selected columns is fixed.
Active Query Builder 2 WinForms Edition v.2.9.0.684
+ The new feature "User Queries" is added to allow for creation of reusable virtual objects containing a previously saved query. + The new "Reusable Queries" pane is added below the Database Schema Tree. Use the PanesConfigurationOptions.UserQueriesPaneVisible property to show/hide this pane. To save and load ueser queries use import/export methods of the QueryBuilder.UserQueries object. + The Show Query By Parts demo is replaced with the improved SubQuery Results Preview demo. + Query Transformer now supports Skip() with ROW_NUMBER ranking function for DB2 and MS SQL Server 2005-2008. + MS Access: Query Transformer is able to use Limit() with MS Access now. - MS SQL Server: The mistyped DATETIMEOFFSETFROMPARTS function name is corrected. - DevExpress: Crash on Delete command of the CTE tab context menu is fixed. - The bug on closing last datasource in CTE is fixed.
Active Query Builder 2 WinForms Edition v.2.8.3.682
- DevExpress: Painting of focused items in some controls is corrected. - A fix for the problem with some types of recursive CTE 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!