Downloads

Active Query Builder 3 ASP.NET Edition History

March 13, 2019

Active Query Builder 3 ASP.NET Edition v.3.4.2

- Expanding fields for tables in the search results of Database Schema Tree 
  by clicking on the expand/collapse indicator is possible now. 
+ The new AQB.Web.QueryBuilder.makeLayout method has been added to create 
  the component's layout. It should be used when the component is not visible
  on page load.

March 11, 2019

Active Query Builder 3 ASP.NET Edition v.3.4.1

+ Support for the .NET Standard 2.0 has been made.
! Breaking change: The display of alternate names and other SQL generation
  options for expressions in the user interface is now determined by the
  QueryBuilder.SQLFormattingOptions property (rather than the
  QueryBuilder.SQLGenerationOptions). The QueryBuilder.SQLGenerationOptions
  now influence only on the query text generation returned by the
  QueryBuilder.SQL property.  
- Other minor improvements and bugfixes have been made.

February 15, 2019

Active Query Builder 3 ASP.NET Edition v.3.4.0

+ The new Grid.addExpression method has been added. It accepts string
  expression and a callback function as parameters and puts the newly
  created grid row as a parameter of the callback function.
- The bug with renaming subfolders and queries in them has been fixed.
- The bug the grid.scrollToTop, scrollToBottom methods which caused 
  unwanted scrolling of the grid on deleting a row has been fixed.
= The obsolete property UseDefaultTheme has been removed.

February 06, 2019

Active Query Builder 3 ASP.NET Edition v.3.3.7

- Search in the Database Schema Tree if alternate names are defined and
  visible is performed correctly now.
- The BehaviorOptions.LinkManipulations property now works as it should.
- Turning off grouping in the query via the global Grouping checkbox in the
  header of Query Columns List may lead to inconsistent queries. Fixed now.

December 20, 2018

Active Query Builder 3 ASP.NET Edition v.3.3.6

+ The new demo for NancyFX to illustrate the definition of custom HTTP 
  context has been added.
= SQL text parsing and generation have been speeded up.

November 26, 2018

Active Query Builder 3 ASP.NET Edition v.3.3.5

- The "OutputStream error" in WebForms with AJAX requests has been fixed.
- The bug in the AddStoredProcedure function has been fixed.
- The bug in the JavaScript header.setColumnWidth function has been fixed.

November 02, 2018

Active Query Builder 3 ASP.NET Edition v.3.3.4

+ Events for query object model actions have been added to the QueryBuilder
  object: DataSourceAdded, DataSourceFieldAdded, DataSourceFieldRemoved,
  LinkChanged, LinkCreated, QueryColumnListItemChanged. 
- Memory leaks when QueryBuilder object is not explicitly disposed have 
  been fixed. 
- Query Column Grid markup bugs have been fixed.

October 18, 2018

Active Query Builder 3 ASP.NET Edition v.3.3.3

+ New client-side events of user actions with queries on the Canvas have
  been added. (datasources, fields, and links: creation, changing, and
  removal). The complete list can be found here.
+ New samples illustrating on-demand component loading have been added:
  - to the MVC demo project: Change Connection using Partial View, 
    Deferred Query Builder creation.
  - to the JavsScript Client-side rendering project: Change Connection.
= SQL parsing error message is generated in accordance with the client
  language now.
- The Query Columns Grid HTML layout error in IE has been fixed.
- Scrolling in the Query Navigation Bar has been fixed.
- Memory leak after the QueryBuilder.dispose method call has been
  eliminated.

September 20, 2018

Active Query Builder 3 ASP.NET Edition v.3.3.2

- OLE DB Metadata Provider: Loading of the PrimaryKey flag from the Indexes
  collection has been fixed.
- The bug with duplication of the column list for objects in the query which
  weren't uniquely identified has been fixed.
- Multi-thread concurrent execution issue has been fixed.

September 13, 2018

Active Query Builder 3 ASP.NET Edition v.3.3.1

= Single-line text box is used to edit Top query property now.
= Minor change to avoid inconsistent SQL query state by has been made. 
  Grouping is now automatically turned on for the column turned visible if 
  there is grouping or aggregates in the sub-query.
= New params for the SubQuery.GetSqlForDataPreview function instruct to add
  a row limitation clause to the returned query. Default values prescribe
  not to add this clause (int skip = 0, int count = -1).
- The bug with the "Uncheck all" datasource command has been fixed.
- MS SQL Server: Loading databases for linked servers has been fixed.
- Minor fixes in demo projects 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