Active Query Builder 3 WPF Edition v.3.3.22.1069
= Parsing of large Oracle SQL queries has been speeded up. + The new Link.ReferencedDataSources property has been added. + The new UserQueriesControl.SelectedItemChanged event has been added. = Creation of referencing loops of virtual objects is not possible now. - Drag'n'drop in the User Queries Control has been fixed. - The bug with presence of the "empty node" item in folders of the User Queries Control has been fixed. - MySQL: Parsing of DateDiff function has been fixed. - The bug with localization of the Add Object Dialog has been fixed. = The new "Execute Query" action has been made in the Full-Featured MDI Demo project.
Active Query Builder 3 WPF Edition v.3.3.21.1068
- MySQL: Some valid identifiers were erroneously treated as keywords. Fixed now. - The bug with selection from the drop-down list of Expression column in the Query Columns List has been fixed.
Active Query Builder 3 WPF Edition v.3.3.21.1067
+ PostgreSQL: Support for "$n"-style positional parameters has been added. - Drop-down editors in the Query Columns List have been fixed. - Unwanted switch to the main query on adding new sub-query has been fixed.
Active Query Builder 3 WPF Edition v.3.3.20.1066
- The bug on loading component with non-empty query inside the Telerik RAD panel has been fixed. - The bug on entering a value to the cell of Query Columns List control that doesn't exist in a combo box suggestion list has been fixed. - The bug with visibility of the Design Pane Preview area has been fixed. - The bug with the links remaining on the Design Pane after clearing the query has been fixed. - Oracle: List of keywords used as valid identifiers has been updated. - MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been added. = Methods to save and load user queries to XML have been moved to the SQLContext class. - Minor bugfixes and improvements have been made.
Active Query Builder 3 WPF Edition v.3.3.19.1065
+ The Design Pane Preview area has been made to let quickly navigate over
large diagrams.
+ The new StatisticsField.IsDirectlyMentioned property has been added.
It indicates whether a field is directly mentioned in the query or just
appears in the query result as a result of the expansion of an asterisk
item ("*") in the SELECT list.
= User queries structure has been moved from the UserQueries control to
the SQLContext.UserQueriesStructure property.
- SQL Text Editor: Word wrapping has been fixed.
Active Query Builder 3 WPF Edition v.3.3.18.1065
+ MS SQL Server: Support for SELECT into local variable has been added. (SELECT @localVar = ...) - The bug with resolving baseName.fieldName references for stored procedures and table-valued functions has been fixed. - The bug with not refreshing fields for objects in the main query via RefreshDatasourcesMetadata call has been fixed. - The bug with not allowing to expand object type grouping nodes (Tables, Views, ...) in the Database Schema Tree has been fixed.
Active Query Builder 3 WPF Edition v.3.3.17.1064
+ Text Editor: Oracle LISTAGG function template has been added. = StreamLog: The underlying stream is flushed now on every write. - CriteriaBuilder: Loading conditions with BETWEEN operator for datetime columns has been fixed. - PostgreSQL: Autodetection has been fixed in the Auto Syntax Provider. - Syntax detection process is logged now in the Auto Syntax Provider.
Active Query Builder 3 WPF Edition v.3.3.16.1063
+ The new IDatabaseSchemaView.ValidateItemContextMenu event has been made. It lets customize context menu of the Database Schema Tree items. + The new IDatabaseSchemaView.ExpandItem has been made to expand the tree down to the specified item and scroll down to it. + Position of an invalid object can be obtained from the SQLParsingException on parsing a query when ParsingErrorOnUnknownObjects property is set to True. - Crash in the Expression Editor while changing the value has been fixed. - Drag & drop of objects from the Database Schema Tree to Design Pane has been fixed. - MetadataLoadingOptions.IncludeFilter/ExcludeFilter: filtration by object type only has been fixed. - Caret position on mouse clicking in the TextEditor has been corrected. - SQL Text Editor: Apostrophes in quoted identifiers don't break the highlighting now. - The QueryBuilder.LayoutSQL property now accept empty strings without errors. - Correct column prefix now emitted for UDFs and stored procedures without aliases.
Active Query Builder 3 WPF Edition v.3.3.15.1063
+ The new IDatabaseSchemaView.ValidateItemContextMenu event has been added to allow the creation of custom context menu for items in the Database Schema Tree.
Active Query Builder 3 WPF Edition v.3.3.14.1062
= The new property DatabaseSchemaView.Controller has been added. - The AllowEdit check before the ValidateContextMenu call in the CustomTreeView has been removed.
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!