Active Query Builder 2 WinForms Edition v.2.6.0.617
= The icon for referencing objects menu item has been changed. - Recursion loop detection on building result SQL with virtual fields is made. - Oracle: The schema loading query is corrected to load schemas that have no tables, but contain other types of database objects. - Query Transformer: Filters were applied incorrectly to wrapped queries. Fixed now.
Active Query Builder 2 WinForms Edition v.2.6.0.616
! The bug with broken ReferencedObject name in ForeignKey is fixed. = Items in the Linked Objects menu now sorted alphabetically. - Loading of joins in WHERE clause with subqueries referencing other datasources is fixed. - PostgreSQL: Support for ORDER BY in aggregate functions is added. - MS SQL Server: "PARSE" is valid identifier now. - MS SQL Server: The conflict between "char", "nchar" identifiers and same-named built-in functions is solved. = MS SQL Server: Parsing of nested function calls is optimized for speed.
Active Query Builder 2 WinForms Edition v.2.6.0.615
+ Criteria Builder: If criteria column contains a foreign key, the control now shows referenced table in the lookup window. + Criteria Builder: The IsValid() method is added. It allows to check whether all values in the control are filled and valid. - Auto-detection of Teradata, MS SQL CE and Azure database servers is fixed. - Sybase ASE: A workaround for buggy AseDataReader.GetOrdinal() ADO provider method is made. - Oracle: Parsing of PARTITON with OUTER JOIN is fixed. - PostgreSQL: Support for AT TIME ZONE expression is made. - PostgreSQL: Support for the ROW constructor expression is made. - PostgreSQL: The EXTRACT function is fixed.
Active Query Builder 2 WinForms Edition v.2.5.5.614
= MS SQL Server: Query builder now loads only accessible databases, for which the user has CONNECT provilege. - Switching of Syntax Provider without reloading the query is possible now. - Foreign keys where affected when metadata filtering is used. Fixed now.
Active Query Builder 2 WinForms Edition v.2.5.5.613
+ ODBC: Metadata loading for old ODBC drivers is fixed. - Unpaired fields in foreign key definitions (MetadataForeignKey) are ignored when adding links on the Design Area.
Active Query Builder 2 WinForms Edition v.2.5.4.612
- The broken auto-layout of objects on sub-query tabs when loading a query from the text is fixed. - Tab order in Datasource Properties form is fixed. - SQL Text Editor: Backward search from the end of text is fixed.
Active Query Builder 2 WinForms Edition v.2.5.4.611
- The NullReferenceException in the AutoSyntaxProvider is fixed. It was raised when the MetadataProvider property was set to null.
Active Query Builder 2 WinForms Edition v.2.5.4.610
= DevExpress references are updated to v.13.1.8.0.
Active Query Builder 2 WinForms Edition v.2.5.4.609
+ Criteria Builder: Filtration of lookup list values by text from the text box is made. + XML Documentation files for assemblies are added to the installation package. = Documentation is updated. - Expression Editor: The bug with ShowSuggestionAfterCharCount property causing problems in the Form designer is fixed.
Active Query Builder 2 WinForms Edition v.2.5.3.608
- Check boxes painting at non-standard display resolution settings (120 DPI and more) 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!