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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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:
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!