Downloads

Active Query Builder 3 Core Edition History

July 29, 2016

Active Query Builder 3 Core Edition v.3.1.1.1023

- Query Statistics: Minor memory leak is fixed.
- Query Statistics: Statistics calculation for nested CTE is fixed.

July 26, 2016

Active Query Builder 3 Core Edition v.3.1.1.1022

- Fixes for servers which doesn't support using aliases in GROUP BY are made.
- PostgreSQL: User-defined prefix operator precendence fix is made.

July 07, 2016

Active Query Builder 3 Core Edition v.3.1.1.1021

- Minor fixes are made.

June 23, 2016

Active Query Builder 3 Core Edition v.3.1.1.1020

- Unhandled exception on removing single union sub-query from parentheses 
  is fixed.

June 10, 2016

Active Query Builder 3 Core Edition v.3.1.1.1019

- Minor fixes are made.

May 11, 2016

Active Query Builder 3 Core Edition v.3.1.0.1018

+ The component now tries to fix invalid aliases in the query on loading.

May 08, 2016

Active Query Builder 3 Core Edition v.3.1.0.1016

- Specific assemblies security fixes for NET Framework 4 are made.

May 06, 2016

Active Query Builder 3 Core Edition v.3.1.0.1015

= Minor compilation warnings are removed. 
- Field names calculation for aliased expressions in sub-queries is fixed.
- Base Metadata Provider: Query to load fields for procedures is fixed.

May 04, 2016

Active Query Builder 3 Core Edition v.3.1.0.1014

! Minimal required version of .NET Framework is raised to 4.0.
- Assignment of aliases for aggregated columns is fixed.
- Source code compilation is fixed.
= Oracle: DBA* views are used now for metadata loading if available.
- MS SQL Server: Loading additional information about fields from 
  non-default  databases is fixed.
= The MetadataForeignKey.ReferencedObject property now accepts alternate
  names.
= MS SQL Server: Parsing speed is improved.
+ Oracle: Database links support is made. 
  To make objects from database links visible in Database Schema Tree, turn 
  the the QueryBuilder.MetadataLoadingOptions.LoadDafaultDatabaseOnly 
  property to False.
+ Sybase: Metadata retrieval from SAP IQ is made.
- MS SQL Server: Fetching stored procedure parameters from system catalog 
  is fixed.
- DB2: Fetching description for synonyms is fixed.
- Teradata: Fields are sorted by default by ColumnId.
- The behaviour of the MetadataFilterItem.Exclude setter is corrected.

April 04, 2016

Active Query Builder 3 Core Edition v.3.0.4.1008

+ Chinese (Taiwan) translation is added.
+ The new Query Transformer demo is added.
- 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.
- Query Transformer: SQL wasn't updated on changing the column.Visible
  property. Fixed now.
- The OracleSyntaxProvider.IsSupportSubQueryCTE is set correctly now.
- The bug with reseting SortType to Ascending after setting the 
  QueryColumnListItem.SetSortOrder property is 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