Downloads

Active Query Builder 2 WinForms Edition History

December 29, 2015

Active Query Builder 2 WinForms Edition v.2.10.5.753

- Critical bug in the Query Transformer is fixed.
- MS SQL Server: Parsing of date part identifiers is fixed.

December 15, 2015

Active Query Builder 2 WinForms Edition v.2.10.5.752

+ Oracle: implemented data type computation in expressions.
= Recognition of IN clauses and date literals in expressions is improved.
- ODBC literals and function call syntax are fixed in all syntax providers.
- PostgreSQL: Support of UESCAPE in unicode string literals is added.
- Oracle: Support for ListAgg and XmlAgg in analytic expressions is added.
- MS SQL Server: Added date parts to the list of valid identifiers.
= ValidateQuery() now throws exception if SELECT list is empty.

November 16, 2015

Active Query Builder 2 WinForms Edition v.2.10.4.750

- The bug that caused crash on right-clicking on the link when 
  BehaviorOptions.LinkManipulations is set to LinkManipulations.Deny is fixed.

November 02, 2015

Active Query Builder 2 WinForms Edition v.2.10.4.748

- Generation of Common Table Experssions (CTE) is corrected.
- Inoperable CreateWhereJoinsByDefault property is fixed.
= Grouped expressions are loaded with default condition type "For values".
- SearchBox layout distortion when changing QueryBuilder font is fixed.
= Installer: Start Menu items are optimized to avoid menu littering on 
  Windows 10.

October 16, 2015

Active Query Builder 2 WinForms Edition v.2.10.3.747

- Delay on opening the Add Object Form on large database schema is
  significantly reduced.

October 14, 2015

Active Query Builder 2 WinForms Edition v.2.10.3.746

- SQL Server: Indetermination on parsing of method call is fixed. 
- MySQL: Loading of referencing objects is corrected.

October 06, 2015

Active Query Builder 2 WinForms Edition v.2.10.3.744

- Oracle: CYCLE identifier parsing is fixed.
- The exception in sub-query statistics is eliminated.
- The exception in CTE queries when syntax provider is disposing is fixed.

September 16, 2015

Active Query Builder 2 WinForms Edition v.2.10.3.742

! Hotfix: Exception on adding the same table on the design pane twice 
  is eliminated.

September 15, 2015

Active Query Builder 2 WinForms Edition v.2.10.3.741

= SQL Text Editor: Keywords and functions dictionaries for Netezza syntax
  are added.
- Netezza: Automatic server detection is fixed.
- Crash in the Query Structure Demo sample project is fixed.

September 02, 2015

Active Query Builder 2 WinForms Edition v.2.10.3.739

Criteria Builder is significantly improved:
+ It is now syncronized with the QueryTransformer object both ways.
+ The new SQLUpdated event is added. It is fired after any change in the
  items when all items are valid.  
+ The new "is empty" and "is not empty" operators are added for string
  columns.
+ Most of the string operators are applied to for columns with unknown
  data type.
- Processing of LIKE-derived operators for columns with unknown types is
  fixed.
- The ValidateDataType event was not fired for column with custom SQL
  expression in some cases. Fixed now.
- The Null reference exception when pressing the lookup button for column
  with custom SQL expression is eliminated.

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:

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