Downloads

Active Query Builder ActiveX Edition History

February 10, 2016

Active Query Builder ActiveX Edition v.1.26.13

= Firebird: Domain name is shown now instead of type name in datasource
  field lists.
- Database Schema Tree wasn't scrolled to the top after reload. Fixed now.
- The SubQuery.Clear clears the WITH clause as well.

February 02, 2016

Active Query Builder ActiveX Edition v.1.26.12

+ API reference in CHM format is added.
+ Help strings are added for all Interfaces, Methods and Properties in the
  type library.
= Metadata Tree size is constrained now.
= Design Pane: Aggregated fields are checked now in Datasource controls.
- The TAB key behaviour in the last column of Select List is fixed.

January 25, 2016

Active Query Builder ActiveX Edition v.1.26.11

= The control doesn't get disconnected on setting the ConnectionTimeout and
  CommandTimeout properties.

January 22, 2016

Active Query Builder ActiveX Edition v.1.26.10

+ Query Column List Control now always displays the "Delete item" button.
+ MS SQL: Support for COLLATE clause for column expressions is made.
- Access Violation in the "Remove CTE" event handler is eliminated.
- Double firing of the OnSQLUpdated event is fixed.
= Non-zero default values are set for the ConnectionTimeout and 
  CommandTimeout properties of a new AQB instance.
= Localizer: CurrentLanguage property accepts -1 as "no language" value.

December 23, 2015

Active Query Builder ActiveX Edition v.1.26.8

- The installer, OCX and CAB are signed using SHA256 algorithm.

December 21, 2015

Active Query Builder ActiveX Edition v.1.26.7

- Access violation is fixed in the TacSelectItem.SetConditionString method.
- Assert on datasource deletion in rare cases for complex queries is fixed.

December 10, 2015

Active Query Builder ActiveX Edition v.1.26.6

- Minor fixes in the Metadata Container Editor and Loader forms are made.

December 09, 2015

Active Query Builder ActiveX Edition v.1.26.5

+ MS Access: Support for CONVERT builtin function is made.
+ PostgreSQL: Support for POSITION builtin function is made.
- Oracle: PRECISION, NULLS, TIME, READ, INTERVAL are treated as valid
  identifiers now.
- Oracle: The "List index out of bounds" error in data type calculation is
  fixed.

December 06, 2015

Active Query Builder ActiveX Edition v.1.26.4

+ Polish translation is added.
+ Oracle: Calculation of SQL expression data types is made.
- Better "IN" lists and date literal recognition in the select list is made.
- MS SQL Server: Date parts are added to the list of valid identifiers.
- ODBC "fn" call is fixed.

November 16, 2015

Active Query Builder ActiveX Edition v.1.26.3

+ ODBC literals and function calls syntax is supported now in all SQL
  syntaxes.
- MS SQL Server: YEAR, MONTH and DAY can be used as valid identifiers now, 
  the YEAR builtin function is fixed.
- MS SQL Server: Support for DateAdd function is fixed.
- Oracle: support ListAgg and XmlAgg in analytic expressions
- Oracle: add CYCLE to valid identifiers list
= Advantage DB: Support for Position function is added.
+ PostgreSQL: Support for UESCAPE in unicode string literals is made.
= Condition type column for rows with empty criteria is set now to 
  "for values" in the query columns grid.
- A lot of minor optimizations, improvements and bug fixes are 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