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 3 WPF 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. - 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 3 WPF Edition v.3.4.8.1085
+ The new property DataSourceOptions.CheckboxesVisible lets turn off checkboxes in datasource field lists. = Expression Editor: Focus is now set into the text editor after insertion from suggestion lists. = Support of theming has been improved. - Several unhandled exceptions have been eliminated.
Active Query Builder 3 WPF Edition v.3.4.7.1084
= Sqlite: Keywords list has been filled. = Full-featured demo projects: SQL Syntax detection and changing is possible now for ODBC and OLE DB connections. = Detection of installed OLE DB providers suitable to work with MS Access has been made. = The new Expression Editor Demo has been added to the trial installation package. = The General Demo has been renamed to Basic Demo. - The bug with the stored procedure parameters retrieval on servers with specific collation has been fixed. - Criteria Builder: The bug with creating filter items for empty general conditions has been fixed. - SQL Text Editor: Minor suggestion list fixes have been made. - Minor bugs and improvements in the Query Column List control have been made.
Active Query Builder 3 WPF Edition v.3.4.6.1083
+ The new Expression Editor demo project has been added. It demonstrates the internal structure of the ExpressionEditor component. = SQL Text Editor: Minor auto-completion improvements have been made. = Parsing of incorrect/incomplete "IN" expressions in condition cells of the Query Columns List has been improved. - The bug with displaying multiline string literals on a single line has been fixed. = Logging of the stored procedure params loading has been improved. - Query Column List Control is responsible now with the first mouse click. - The NullPointerException when leaving empty condition item in the Query Columns List has been fixed. - Expression Editor: Minor visual fixes and improvements have been made.
Active Query Builder 3 WPF Edition v.3.4.5.1082
- Minor fixes 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!