Active Query Builder 3 WinForms 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. - Minor scaling issues have been fixed.
Active Query Builder 3 WinForms 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 WinForms Edition v.3.4.16.1093
= References to DevExpress have been updated to v.18.1. = Oracle: Support for the new Oracle 12c LISTAGG syntax has been added. - WinForms: Minor fixes and improvements for the Database Schema View have been made (Border style, multi-select). - Teradata: The bug with autodetection of new versions has been fixed.
Active Query Builder 3 WinForms 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) - The bug with side panels visibility has been fixed.
Active Query Builder 3 WinForms 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. - DevExpress: Applying themes to the SQL Text Editor has been fixed. - DevExpress: The bug with displaying the suggestion popup has been fixed. = DevExpress: SqlTextEditor.BorderStyle property type has been changed from Windows.Forms.BorderStyle to DevExpress.XtraEditors.Controls.BorderStyles.
Active Query Builder 3 WinForms 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 WinForms 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.
Active Query Builder 3 WinForms Edition v.3.4.11.1088
+ Pervasive: Support for Pervasive PSQL (Actian Zen) has been added.
Active Query Builder 3 WinForms 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 3 WinForms Edition v.3.4.9.1086
- SQL Text Editor: The bug with incorrect word wrapping has been fixed. - SQLite: Parsing of queries with RIGHT and FULL joins now results in the parsing error. - The bug with black cell background in the Query Column List Control has been fixed. - IBM DB2: NULL is parsed now as a constant, not as an identifier. - MS SQL Server: Parsing of qualified names with skipped components has been fixed. - MS SQL Server: Loading of fields for linked servers without database or schema has been 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!