Downloads

Active Query Builder History History

January 17, 2013

Active Query Builder History v.0.7.0

+ The new SubQueryNavigationBar is added to manage sub-queries. 
  It's UnionNavBarVisible property determines visibility of the Unions 
  navigation controls within this bar.
- Minor bugs are fixed.

January 16, 2013

Active Query Builder History v.1.19.7.1

+ Support of Teradata syntax is made. The xsTeradata (=120) constant should be
  assigned to the SQLSyntax property to use this syntax.
= Conditions like "<= @DT_END AND >= @DT_START" are loaded into one cell now.

January 16, 2013

Active Query Builder History v.1.19.7.1

= Conditions like "<= @DT_END AND >= @DT_START" are loaded into one cell now.

January 15, 2013

Active Query Builder History v.1.5.7.1123

- Oracle: Support for KEEP expression is added.
- Oracle: Parsing of CONNECT BY expression is fixed.
- Sybase: Parsing of START AT clause is fixed.

January 14, 2013

Active Query Builder History v.2.1.2.543

- The QueryBuilder.Clear() method is fixed.
- Oracle: Support for KEEP expression is added.

January 14, 2013

Active Query Builder History v.1.19.7

+ Oracle: Support for KEEP expression is added.
+ An algorithm of choosing datasources for links with complex expressions is
  improved.
+ Double clicking on a datasource column moves focus to the first criteria cell
  of the newly added criteria item.
+ Select item alias is used as subquery tab caption now.
- Query Builder background and link colors are changed to system constants.
- MS SQL Server: "PATH" is treated as a valid identifier now.
- Sybase: FIRST clause is fixed.
- Sybase: Query limit transformation is fixed.
- Oracle: Usage of ANY, ALL and SOME in comparison expressions is fixed.
+ Interbase: ROWS clause is supported now.
+ MS SQL Server 2012: Parse and Try_Parse functions are supported.
+ MS SQL Server 2012: ROW and RANGE clause in OVER expression are supported.

January 14, 2013

Active Query Builder History v.1.19.7

+ Teradata syntax provider is added.
+ Oracle: Support for KEEP expression is added.
- MS Access: Builtin functions are moved from ATG to the syntax provider.
+ An algorithm of choosing datasources for links with complex expressions is
  improved.
+ Double clicking on a datasource column moves focus to the first criteria cell
  of the newly added criteria item.
+ Select item alias is used as subquery tab caption now.
- Query Builder background and link colors are changed to system constants.
- Query limit transformation method signature is changed.
- The TacUnionSubQuery.SetSql method does not ignore the ORDER BY clause now.
- MS SQL Server: "PATH" is treated as a valid identifier now.
- Sybase: FIRST clause is fixed.
- Sybase: Query limit transformation is fixed.
- Oracle: Usage of ANY, ALL and SOME in comparison expressions is fixed.
+ Interbase: ROWS clause is supported now.
+ MS SQL Server 2012: Parse and Try_Parse functions are supported.
+ MS SQL Server 2012: ROW and RANGE clause in OVER expression are supported.
- Delphi XE3 compilation warnings are fixed.

January 09, 2013

Active Query Builder History v.2.1.2.542

= References to DevExpress assemblies are updated to v12.2.5.0.
= The Standalone Metadata Editor is made for Active Query Builder 2 .NET.
= Metadata Structure Demo is updated.
- A crash on recurring query updates (e.g. on double TextBox Leave event in some
  specific UI layouts) is fixed.
- SQL Text Editor: The FindDialog was not disposed with the parent component.
  Fixed now.
- OracleNativeMetadataProvider: References are fixed in the project file.
- Metadata Editor: Minor fixes are made.

December 26, 2012

Active Query Builder History v.1.17.10.399

+ Support for Teradata Database is added. Use the new TeradataSyntaxProvider
  to build and parse queries for this database. Use the UniversalMetadataProvider
  to work with native ADO.NET provider, use OLE DB or ODBC metadata providers
  to connect via respective drivers.

December 19, 2012

Active Query Builder History v.2.1.2.540

- SQL Text Editor: Reaction on selected text clicking is fixed.
= Installer now remembers integration checkboxes choice on uninstall.

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