Downloads

Active Query Builder 3 WinForms Edition History

January 03, 2018

Active Query Builder 3 WinForms Edition v.3.4.0.1075

+ SQL expressions error handling.
+ Query inconsistency alerts.
+ Easy addition of linked objects to the query.
+ Search and filtration in field list of objects on Design Pane.
+ Keyboard shortcuts in Design Pane.
+ Metadata loading acceleration.
+ Other improvements.

December 29, 2017

Active Query Builder 3 WinForms Edition v.3.3.26.1074

+ On-demand metadata loading improvements have been made to speed up field
  list retrieval when adding a new object to the query.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  an arbitrary order has been fixed.
- Minor localizer bug has been fixed.
- SQL Text Editor: The bug with Undo operation has been fixed.

December 13, 2017

Active Query Builder 3 WinForms 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.
- SQL Text Editor: The bug with caret position after removing a character
  and scrolling has been fixed.
- SQL Text Editor: The bug with the content of suggestion window not 
  taking the last input character into account has been fixed.
- Loading of stored procedure parameters from metadata XML files has been
  fixed.
- Incorrect re-ordering of rows by drag'n'drop in the Query Columns Grid 
  has been fixed.

November 30, 2017

Active Query Builder 3 WinForms Edition v.3.3.24.1072

- Query Transformer: Applying both pagination and sort order has been fixed.
= SQL Text Editor: "Dual" has been added to the list of suggestions for
  Oracle.
- The bug with black background in cell editors of the Query Column List on
  certain systems has been fixed.

November 27, 2017

Active Query Builder 3 WinForms Edition v.3.3.24.1071

- Restoring layout of datasources in the query after manual changing the
  query has been fixed.
+ The new "Go To Expression" context menu item has been added for 
  sub-queries in expressions.
+ New properties have been added to the AddObjectWindowOptions group: 
  Width, Height, Position, Location, ImageIndices.
= Query Column List: Conditions recognition and correction has been
  improved.
- User Queries Structure assignment has been fixed.
= 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.
- The bug with dragging CTE from the query navigation bar to the Design 
  Pane has been fixed.
= References to DevExpress controls have been updated to the version 17.2.3.
- Other improvements and bug fixes have been made.

October 18, 2017

Active Query Builder 3 WinForms Edition v.3.3.23.1070

- Hi-DPI scaling issues have been addressed.
- The bug with expanding custom metadata structure items has been fixed.
- The bug with not clearing the ORDER BY clause on assigning new text to
  a sub-query.

October 13, 2017

Active Query Builder 3 WinForms Edition v.3.3.22.1069

= Parsing of large Oracle SQL queries has been speeded up.
+ The new Link.ReferencedDataSources property has been added.
+ The new UserQueriesControl.SelectedItemChanged event has been added. 
= Creation of referencing loops of virtual objects is not possible now.
- MySQL: Parsing of DateDiff function has been fixed.
- The bug with localization of the Add Object Dialog has been fixed.
= The new "Execute Query" action has been made in the Full-Featured MDI 
  Demo project.

September 27, 2017

Active Query Builder 3 WinForms Edition v.3.3.21.1068

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

September 26, 2017

Active Query Builder 3 WinForms Edition v.3.3.21.1067

+ PostgreSQL: Support for "$n"-style positional parameters has been added.
- Unwanted switch to the main query on adding new sub-query has been fixed.

September 22, 2017

Active Query Builder 3 WinForms 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.
- Minor bugfixes and improvements have been made.

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