Downloads

Active Query Builder 2 ASP.NET Edition History

July 25, 2016

Active Query Builder 2 ASP.NET Edition v.2.11.5

+ Now it's possible to add field to the query by double clicking on
  it in datasource field list on Design Pane.
= The QB.Web.Application.resetLayout() method now repaints the canvas.
= Reference to the Newtonsoft.Json assembly is updated to the latest
  version.
- The bug with procedure parameters request is fixed.
- The bug with incorrect determination of datasource on Design Pane for 
  aggregated columns is fixed.

June 16, 2016

Active Query Builder 2 ASP.NET Edition v.2.11.4

- The bug with aggregate functions when QuoteAllIdentifiers property is set 
  to All is fixed.
- The "Loading..." label in the Database Schema Tree is hidden now after
  database connection error.
- Demo projects: Connection errors are shown now in the status bar 
  instead of writing them to log file.

May 10, 2016

Active Query Builder 2 ASP.NET Edition v.2.11.3

- Minor bugfixes are made.

April 20, 2016

Active Query Builder 2 ASP.NET Edition v.2.11.2

- The bug with adding duplicate expression to the Query Columns Grid is fixed.

April 15, 2016

Active Query Builder 2 ASP.NET Edition v.2.11.1

+ The new AutoExpandSingleNode property is added to instruct the component
  to expand child nodes if there is only one namespace node is available 
  at the current level.
- Very slow loading of the Database Schema Tree in some cases is fixed.
- The bug with setting Sort Type to "None" is fixed.

March 28, 2016

Active Query Builder 2 ASP.NET Edition v.2.11.0

= Icons are updated.
- Sybase: Compatibility with Sybase IQ is restored.

March 23, 2016

Active Query Builder 2 ASP.NET Edition v.2.10.17

+ The Sub-query Navigation Bar is re-designed.
+ New design and icons are applied.
+ Chinese (Taiwan) translation is added.
+ Select lists for month and year are added to the dropdown editor for date
  values in Criteria Builder.
+ The new "Clear" button is added to Criteria Builder.
+ The new event QB.Web.Application.GridComponent.CustomEditControl is added
  to override the default cell editor type.
+ The new ObjectTreeView.SortOrder property that determines ascending or
  descending order is added.
- The bug with not keeping the original objects order when SortingType is
  set to "None" is fixed.
= Database Schema Tree: Descriptions for synonyms are taken from referred
  objects if it's not defined for synonym itself.
= Advantage DB: The "use object names as default alias" flag is turned on.
- Trial: Random aliases are kept the same for result query generated by the
  Query Transformer.
- Database Schema Tree: Only field nodes are shown under the table nodes
  now.
- Query Transformer: SQL wasn't updated on changing the column.Visible
  property. Fixed now.
- Parsing of the "in (subquery)" expressions in condition cells is fixed.

March 04, 2016

Active Query Builder 2 ASP.NET Edition v.2.10.14

- The bug with Sort Order in the Query Columns Grid is fixed.
+ The new event QB.Web.Application.GridComponent.CustomEditControl 
  is added.

March 03, 2016

Active Query Builder 2 ASP.NET Edition v.2.10.13

= The new events LinkChanged and LinkDeleted are added to the
  QueryBuilderControl class.
= The new SQL Syntax Highlighting Demo is added.

February 29, 2016

Active Query Builder 2 ASP.NET Edition v.2.10.12

= The UnionSubQuery methods to get parts of the SQL text are published:
  GetSelectClauseString, GetFromClauseString, etc.

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:

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