Downloads

Active Query Builder 3 ASP.NET Edition History

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.

September 03, 2018

Active Query Builder 3 ASP.NET Edition v.3.3.0

+ The new QueryBuilderControl.Theme property has been made to switch styling
  between several predefined schemes. The current version supports jQueryUI
  and BootStrap styling out of the box. Allowed property values: 'default',
  'jqueryui' and 'bootstrap'. See the demos marked with the 'Bootstrap' and
  'JqueryUI' labels. 
+ The new AQB.Web.theme property allows applying custom styling scheme on
  the client-side. See the demo with the 'Foundation' label to find the
  sample of applying custom styling. 
+ The new Japanese localization is made. 
= Eight localizations are updated and proofread by professionals: German,
  French, Spanish, Portuguese (Brazil), Chinese (Traditional), Italian,
  Turkish, and Russian. 
! The behaviour of the DefaultExpandMetadataType property has been changed. 
  Now the types listed in this property will be expanded automatically. 
  The new default value is Database.
+ New methods have been added to the QueryBuilder.GridComponent object:
  - prependEmptyRow adds a new row to the top of the list. 
  - appendEmptyRow adds a new row to the end of the list. 
  - tooltipGetText allows overriding a tooltip for grid cells. 
+ The new QueryBuilderControl.HandlersPath property allows defining a 
  custom path for requests to AQB handler. 
+ The new BaseHandler.DisableRegistration method allows to turn off
  automatic registration of the route to AQB handlers. 
+ Serialization of all component properties is possible now. Use the
  XmlSerializer.Serialize/Deserialize methods for this purpose. 
- The bug with the TreeViewComponent.tooltipGetText event has been fixed. 
- The bug with extra brackets in the Database Schema View has been fixed. 
- Some visual glitches with the grid scrollbars have been eliminated.

July 17, 2018

Active Query Builder 3 ASP.NET Edition v.3.2.5

+ The new method AQB.Web.dispose frees all allocated resources and deletes
  the AQB namespace. 
= The new Custom Expression Editor popup dialog to edit text of SQL
  expressions via multiline text editor with SQL syntax highlighting is now
  added to the "Show Query Results" demo. It displays the formatted text of
  sub-queries and CASE statements and warns the user about errors in SQL
  expressions.
- The bug with displaying "or" and "and" prefixes has been fixed.
- The bug with shifting the content of the Database Schema View in IE has
  been fixed.
- The bug with the horizontal Query Columns Grid scrolling has been fixed.
= Minor fixes in the mobile.layout.css have been made.

July 05, 2018

Active Query Builder 3 ASP.NET Edition v.3.2.4.1

- Criteria Builder: The bug with the bool fields type has been fixed.
- Criteria Builder: The bug with the load of invalid logical expressions has
  been fixed.

July 03, 2018

Active Query Builder 3 ASP.NET Edition v.3.2.4

+ The new "Properties" item has been added to context menus of Objects, Links
  and the Canvas itself (Query properties).
+ Possibility to catch error both on the server and client has been added.
  1. The new BaseHandler.OnException event has been made. It allows 
  overriding the message passed to the client.
  2. The new AQB.Web.QueryBuilder.Events.OnError method allows informing 
  the user about the error in another way.
+ The new property CriteriaBuilder.dateFormat allows changing the date 
  display format. Default value: "dd.mm.yy". Possible values are listed here:
  http://api.jqueryui.com/datepicker/#option-dateFormat
+ The new DataSourceOptions.resizeMode property has been added to change the
  way the user can resize objects in the Canvas. Default value: "se" 
  (bottom-right corner). Possible values are listed here:
  http://api.jqueryui.com/resizable/#option-handles
- Criteria Builder: The bug with the bool fields type has been fixed.
- The bug with displaying splitters in the Internet Explorer has been fixed.
= Other minor changes have been made.

June 22, 2018

Active Query Builder 3 ASP.NET Edition v.3.2.3

+ The new VirtualDirectory option for the configuration file has been added.
  Setting it will override the autodetected value.
+ The message is displayed now on turning to the "Sleep mode" when the user
  enters a query that is not a SELECT statement.
+ The new demo project has been added to illustrate applying custom HTML
  layout to the web page and also presents the new version of HTML layout
  for mobile devices.
- Crieria Builder now correctly handles conditions for strings with spaces.
- The HideAsteriskItem property is applied correctly being set on the page
  for the Canvas control.
- The bug with the columns width out of sync on changing the Query Columns
  Grid width has been fixed.
- Handling of several Query Column List items with the same Expression has
  been fixed.
= The AQB.Web.Core.addGridRow method now applies all properties of the
  passed GridRowDto object.
= The GridComponent.setColumnWidth now accepts values in pixels and 
  percents.

May 10, 2018

Active Query Builder 3 ASP.NET Edition v.3.2.2

+ Corporate version is now available for download and upgrade.
+ Demo projects for VB.NET are included in the installation package.
= Autodetection of the used virtual directory has been made. You still can
  override it via the BaseHandler.VirtualDirectory property.
- The bug with metadata filtration arising in some particular cases has been
  fixed.
- Minor visual bugs have 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:

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