Downloads

Active Query Builder 3 WPF Edition History

May 26, 2017

Active Query Builder 3 WPF Edition v.3.3.7.1054

= Conditions for the same left part joined using the OR operator are merged
  into a single cell now.
= "OR" condition columns in the Query Column List control are created on
  demand now.
- IBM DB2: The method to retrieve the list of schemas now falls back to SQL
  query if loading from driver returns no schemas.
- Referencing objects for User Queries aren't loaded now.

April 28, 2017

Active Query Builder 3 WPF Edition v.3.3.6.1053

= ODBC Metadata Provider: Better detection of servers that don't support
  schemas has been made.
= SQL 92 Syntax Provider allows empty schema names now.

April 25, 2017

Active Query Builder 3 WPF Edition v.3.3.6.1042

- The bug with the editing of custom columns in the Query Columns List
  control has been fixed.
= The text of join SQL expression in the Link Properties dialog and sidebar
  panel is wrapped by words now.
- Dependent options in the properties sidebar panel are correctly enabled
  now upon changing the main property.
- The bug with incorrect caret position, when word wrapping is turned on,
  has been fixed.

April 18, 2017

Active Query Builder 3 WPF Edition v.3.3.5.1041

+ MySQL: Support of MATCH full text search operator has been made.
= IBM DB2: The new DB2SyntaxProvider.ObeySchemaListFromDriver property has
  been added to ensure the priority of the list of objects received from 
  the metadata provider (True by default).
- IBM DB2: The bug with selecting table schema instead of table owner 
  for schema name has been fixed.
- The reference to MySql.Data assembly in MySQL metadata provider has been 
  updated to the version 6.9.9.
- Adorner layer in the QueryColumnListControl has been fixed.

March 24, 2017

Active Query Builder 3 WPF Edition v.3.3.4.1040

+ Captions on the Criteria Builder UI have been improved.
- WPF: Repeated click on the field with a combobox in the Query Columns List
  cleared the displayed value. Fixed now.

March 21, 2017

Active Query Builder 3 WPF Edition v.3.3.3.1039

= Database Schema view in the Expression Editor is now grouped by database 
  and schema.
- The bug with grouping database objects by type has been fixed.
- Properties dialogs were inoperable if there's no Properties sidebar on 
  the form. Fixed now.

March 17, 2017

Active Query Builder 3 WPF Edition v.3.3.2.1038

+ Installer: Integration with Visual Studio 2017 has been added.
= Default prefixes aren't skipped now in item captions in the Database
  Schema View.
= Oracle: Recognition of built-in constants has been improved.
= MS SQL: Recognition of built-in @@-named variables has been improved.
- The bug with removing of the "TOP n" clause in the query text has been 
  fixed.
- User Queries structure tree isn't reloaded now on every SQL query change.
- Exception on opening the Expression Editor has been fixed.
- The checkbox in the header of the Grouping box works properly now.
- A Query Columns List row is removed now on clearing the value of the
  Expression column.
= Constant expressions aren't appended to the grouping list now.
- The bug with keyboard navigation over the Query Columns List has been
  fixed.
- Links on the Design Pane are cleared properly now on switching between
  sub-queries.

March 06, 2017

Active Query Builder 3 WPF Edition v.3.3.1.1037

+ SQLite: Support for the IS operator ("expr IS expr") has been added.
= Automatic links creation for self-linked objects has been improved.
- The bug with re-applying metadata filters has been fixed.
- Minor bugfixes have been made.

February 27, 2017

Active Query Builder 3 WPF Edition v.3.3.0.1036

+ Now when the user selects the query editing command, the
  UserQueriesView.EditUserQuery event is triggered, in which the developer
  can save the current query before opening the new one, or he can open the
  user query in a new window, the way it's done in the updated Full-featured
  demo project. Also, the events are now fired on deleting, renaming and
  moving user queries between the folders. You can review all API changes 
  in the release notes article.
+ The new helper class Core.UserQueries that consists of static methods has
  been added to perform various manipulations with user queries, such as
  adding, saving, moving, renaming them. It also has the means to save and
  load user queries serialized in XML format.
= The updated Professional Full-Featured demo project illustrates the new
  functionality.
+ The data browsing UI is improved in the Full-featured demo project. 
  It now uses the Query Transformer API to modify SQL queries.
+ The new MetadataLoadingOptions.AllowRecursiveVirtualObjects property
  allows specifying the mode of working with virtual objects. By default,
  referring to other virtual objects in the text of a virtual object is
  allowed. Such reference lets build a chain of objects to break complex
  queries in a series of simple ones. However, in this mode, you can't use
  the same-named physical object in a virtual object because of the emerging
  recursion. Setting this property to false prohibits creation chains of
  virtual objects, but allows to create virtual objects that substitute
  physical database objects.
+ The new SQLite metadata provider has been added.
= The Query Structure demo project has been refactored.
- Removal of unused objects from the query when the 
  QueryBuilder.BehaviorOptions.DeleteUnusedObjects property is turned to
  True has been fixed.

January 27, 2017

Active Query Builder 3 WPF Edition v.3.2.2.1035

+ The new SubQueryBreadcrumbsBar control has been made. It makes quickly
  switch to parent sub-queries.
+ The new ActiveUnionSubQueryChanging event has been added to the QueryView
  and QueryBuilder components. It lets deny switching to another sub-query
  that might be helpful if you let end-users edit the text of sub-queries
  apart from the main query, in the case of the sub-query text parsing
  error.
+ The new SubQueryTextEditingDemo project has been added to Professional 
  and Trial installation packages.
+ IBM DB2: The ListAgg function is supported now.
+ Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields
  collections now include invalid objects and fields being used in the
  query. They differ from valid objects by the absence of MetadataObject
  (for objects) and MetadataField (for fields) references.
= The QueryStructureDemo has been refactored.
- The bug with creating Link controllers has been fixed.
- MS SQL Server: DATEPART parser ambiguity has been fixed.

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