Downloads

Active Query Builder 3 WPF Edition History

June 09, 2018

Active Query Builder 3 WPF Edition v.3.4.17.1096

- The bug with primary key links menu item captions has been fixed.

June 08, 2018

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.

May 29, 2018

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.

May 28, 2018

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.

May 18, 2018

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)

May 16, 2018

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.

May 08, 2018

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.

May 04, 2018

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.

April 23, 2018

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.

April 14, 2018

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.

Product Summary

 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:

News

Tweets

Testimonials

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!


Social networks