Downloads

Active Query Builder 3 Core Edition History

December 13, 2017

Active Query Builder 3 Core Edition v.3.3.25.1073

+ Sybase: Support for window functions has been added.
= User Queries: Exception is thrown now if query expression has output 
  column names conflicts.
= Teradata: Minor metadata loading improvements have been made.
- Loading of stored procedure parameters from metadata XML files has been
  fixed.

November 30, 2017

Active Query Builder 3 Core Edition v.3.3.24.1072

- Query Transformer: Applying both pagination and sort order has been fixed.

November 27, 2017

Active Query Builder 3 Core Edition v.3.3.24.1071

= The QueryStatistics.IsStatisticsValid flag has been hidden. 
+ Oracle: Batch fields and relations loading has speeded up metadata
  loading.
- Oracle: Unsupported comparison operators ("!>", "!<") have been removed.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Firebird: Parsing of Aggregate functions has been fixed.
- Other improvements and bug fixes have been made.

October 18, 2017

Active Query Builder 3 Core Edition v.3.3.23.1070

- The bug with not clearing the ORDER BY clause on assigning new text to
  a sub-query.

October 13, 2017

Active Query Builder 3 Core Edition v.3.3.22.1069

= Parsing of large Oracle SQL queries has been speeded up.
+ The new Link.ReferencedDataSources property has been added.
= Creation of referencing loops of virtual objects is not possible now.
- MySQL: Parsing of DateDiff function has been fixed.

September 27, 2017

Active Query Builder 3 Core Edition v.3.3.21.1068

- MySQL: Some valid identifiers were erroneously treated as keywords. 
  Fixed now.

September 26, 2017

Active Query Builder 3 Core Edition v.3.3.21.1067

+ PostgreSQL: Support for "$n"-style positional parameters has been added.

September 22, 2017

Active Query Builder 3 Core Edition v.3.3.20.1066

- Oracle: List of keywords used as valid identifiers has been updated.
- MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been
  added.
= Methods to save and load user queries to XML have been moved to the
  SQLContext class.

September 13, 2017

Active Query Builder 3 Core Edition v.3.3.19.1065

+ The new StatisticsField.IsDirectlyMentioned property has been added. 
  It indicates whether a field is directly mentioned in the query or just
  appears in the query result as a result of the expansion of an asterisk
  item ("*") in the SELECT list.
+ The SQLContext.UserQueriesStructure property has been added to hold 
  the structure of Reusable queries.

August 25, 2017

Active Query Builder 3 Core Edition v.3.3.18.1065

+ MS SQL Server: Support for SELECT into local variable has been added.
  (SELECT @localVar = ...)
- The bug with resolving baseName.fieldName references for stored procedures
  and table-valued functions has been fixed.

scroll to top
© Copyright 2005-2022 ActiveDBSoft. All rights reserved.
Site Map Terms of Use Privacy Policy

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