Downloads

Active Query Builder 3 WinForms Edition History

June 20, 2021

Active Query Builder 3 WinForms Edition v.3.8.4.2200

- The alignment of links on design pane control has been fixed.
- The execution of pre-compiled demos and the compilation of sample projects 
  have been fixed.
- DevExpress: The unnecessary dependency from System.Resource.Extension assembly
  has been eliminated.

June 12, 2021

Active Query Builder 3 WinForms Edition v.3.8.3.2198

+ Metadata loading wizard has been improved for better synchronization
  between the XML and live database schema.
= Missing localization constants are added.
- The bug with displaying empty Properties Editor after the application load
  has been fixed.
= The default size of SingleLineSqlTextEditor and content alignment has been
  corrected.
- DevExpress: The back color of Query Column List cells has been fixed.
- .NET Core: The alignment of controls in the Properties Editor and Query
  Columns List rows height has been fixed.
- The property editor control for color values has been fixed.
- The location of the Quick Preview Area on Design Pane has been fixed.
= Teradata: The fallback to non-X system views if X-views are not available
  has been made.

May 27, 2021

Active Query Builder 3 WinForms Edition v.3.8.2.1198

= Professional version: References to DevExpress assemblies are updated
  to v.21.1.3. 
= The unnecessary dependency from System.Resource.Extension assembly has
  been eliminated.
= A tooltip for the "show/hide unused fields" button on the design pane is
  added.
= A tooltip for the quick preview design pane control window is added.
= Query Column List: Grouping and aggregation icons are drawn in the check
  box of the "Grouping/Aggregate" column instead of a usual checkmark.
- DevExpress: Null reference exception on showing the context menu has been
  eliminated.
- Null reference exception on inserting a subquery into a cell has been 
  fixed.

May 20, 2021

Active Query Builder 3 WinForms Edition v.3.8.1.1197

= The minimal initial datasource height on Design Pane is limited to fit 
  three fields
- The null reference exception on removing the last CTE from subqueries
  is fixed.

May 19, 2021

Active Query Builder 3 WinForms Edition v.3.8.0.1195

! The new minor version is released. Read the full news story.

April 29, 2021

Active Query Builder 3 WinForms Edition v.3.7.19.1194

+ The user can collapse the Preview area in the bottom-right corner of Design 
  Pane to an icon. It becomes completely hidden when the query diagram fits 
  the Design Pane.
+ It is now possible to switch grouping on and off via the Design Pane context 
  menu.
+ Grouping marker is displayed for fields in the data source field list 
  (curly bracket is now used for grouping; sigma for aggregation). 
= Pervasive: Parsing of the DateAdd, DateDiff, and DatePart functions 
  and DOUBLE built-in type are fixed.
= DB2: Parsing of the EXCEPTION join and parsing backslash as a division in 
  expressions are fixed.
- Scaling of the top-right toolbar on the Design Pane is fixed.
- The update of cell value after using the Expression Editor has been fixed.

March 26, 2021

Active Query Builder 3 WinForms Edition v.3.7.18.1193

+ When the last CTE reference is removed, a prompt to remove from the query 
  the CTE itself contains the link to switch to it.
= Query Structure Demo: The dumping of the WHERE clause is improved.
- Pervasive SQL: The parsing of the IF built-in function is fixed.

March 18, 2021

Active Query Builder 3 WinForms Edition v.3.7.17.1192

- The bug with focusing on a wrong property on clicking the "Fix issue"
  anchor is fixed. 
- Minor localization and other fixes are made.

March 10, 2021

Active Query Builder 3 WinForms Edition v.3.7.16.1191

- Drop position on creating a link has been fixed.
- MySQL: The Query Properties form initialization if there is no 
  SQLCalcFoundRows property is fixed.
- MySQL: The bug with PRECEDING keyword parsing is fixed.

March 03, 2021

Active Query Builder 3 WinForms Edition v.3.7.15.1190

= The length of automatically generated aliases for single-word names is 
  limited to 3 characters.
= The ObjectNamesNormalization property set to False doesn't lead to the 
  full qualification of names added by code and visually.
- MySQL: "POSITION" is added to the list of valid identifiers.
- DevExpress: The bug with clicking on checkboxes next to datasource fields 
  on the Design Pane has been fixed.
- The location of buttons to show/hide unused fields on the Design Pane has
  been fixed.

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