Active Query Builder 3 WPF Edition v.3.4.17.1096
- The bug with primary key links menu item captions has been fixed.
Active Query Builder 3 WPF Edition v.3.4.17.1095
+ Initial support for SAP HANA has been added: metadata retrieval queries, list of built-in functions. = The BaseSyntaxProvider.BuiltinFunctionNames property is public now. = The new helper method MetadataField.GetDataTypeName has been added to get datatype string combining the ServerTypeName, Size and Precision attributes. - Retrieval of referenced objects by foreign keys for unsupported servers has been speeded up. - Hiding the information message when the reported problem is no longer actual has been fixed. - The original Metadata Structure is preserved now after searching to keep the assigned event handlers.
Active Query Builder 3 WPF Edition v.3.4.16.1094
- SQL Text Editor: The bug with building the suggestion list for metadata with loaded linked servers has been fixed. - Minor bug fixes have been fixed.
Active Query Builder 3 WPF Edition v.3.4.16.1093
= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added. - Teradata: The bug with autodetection of new versions has been fixed.
Active Query Builder 3 WPF Edition v.3.4.15.1092
= Logging improvements have been made. = Now trying to cut off garbage in the fields description while fetching metadata from ODBC driver. (a workaround for the bug in MS Access ODBC driver)
Active Query Builder 3 WPF Edition v.3.4.14.1091
+ The new DataSourceAddLinkedObject event has been added to the QueryBuilder, QueryView objects to override the default behaviour on adding a new object to the query which is linked to the existing one. + The new DataSourceOptions.ShowOptionsButton property has been added. It allows hiding the Datasource Options (hamburger) button. = Metadata loading: Field type doesn't get updated by the Metadata Provider now if it is already loaded (show type names instead of domain names). - The Null Reference Exception when asterisk item is hidden has been fixed. - The IAddObjectDialog.MetadataStructure property is now writeable. - Add Object Dialog: The bug with displaying folders in the drop-down list has been fixed.
Active Query Builder 3 WPF Edition v.3.4.13.1090
+ The new method is available now in the SQLQuery service to link a newly added object to other objects having same named fields. The LinkObjectBySameNamedFields accepts a DataSource as a parameter and returns a list of newly added Link objects. - The bug with metadata filtration arising in some particular cases has been fixed. - The Remove context menu item is not displayed for sub-queries in expressions. - The "Image index out of range" error has been fixed.
Active Query Builder 3 WPF Edition v.3.4.12.1089
= SQL Text Editor: The first item in suggestion window is not selected now right after its opening. This eliminates the problem of unnecessary substitutions. - The Query Columns Grid was not updated on clearing the query. Fixed now. - The bug with hiding/showing tabbed panes has been fixed. - The bug with turning off the AutoHide property for a pinned tab has been fixed.
Active Query Builder 3 WPF Edition v.3.4.11.1088
+ Pervasive: Support for Pervasive PSQL (Actian Zen) has been added. - Minor fixes in the Query Column List control have been made.
Active Query Builder 3 WPF Edition v.3.4.10.1087
+ The new method SubQuery.GetSqlForDataPreview has been added to retrieve the text of sub-query along with the referred named queries from the Common Table Expression to organize data preview for sub-queries. + Full-featured demos now use the GetSqlForDataPreview method for data preview. + The new CTEUnitVisible, UnionsUnitVisible properties have been added to the SubQueryNavBar and QueryNavigationBar controls. - Minor bug fixes and improvements have been 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!