Downloads

Active Query Builder 3 WinForms Edition History

August 31, 2021

Active Query Builder 3 WinForms Edition v.3.8.9.2207

= The field context menu in DataSource controls on the Design Pane has been
  improved when grouping is applied, and the field is used in the query
  several times.
- The field sorting icon is fixed in DataSource controls on the Design Pane
  when the field is mentioned in the ORDER BY several times.
- SQL Text Editor: Search and replace functionality has been fixed.
- SQL Text Editor: Pressing the Ctrl+Backspace key combination removes the
  whole word at the left of the cursor. The Shift+Backspace now acts as the
  Backspace key.

August 13, 2021

Active Query Builder 3 WinForms Edition v.3.8.8.2206

= Design Pane diagram painting has been speeded up.
= GrapeCity reports module can be activated in the Full-Featured MDI Demo 
  by turning on the EnableActiveReportsSupport property in the Samples\
  Directory.Build.props file. 
- The keyboard arrow-keys navigation in the Query Column List (move left in
  the Criteria column) has been fixed. 
- The bug with SQL text generation for objects and fields with empty 
  alternate names when the UseAltNames property is true has been fixed.

July 20, 2021

Active Query Builder 3 WinForms Edition v.3.8.7.2205

= The methods to serialize/deserialize query builder option groups are moved
  from the View to Core assembly.
= The bug with SQL query generation with alternate names for servers
  supporting object names as a default alias has been fixed.

July 12, 2021

Active Query Builder 3 WinForms Edition v.3.8.6.2204

= MS SQL Server: Support for TRY_CAST and TRY_CONVERT built-in functions has
  been added.
= Objects in the search results are expandable now. 
= Query model optimization has been made. Datasources aren't reordered now if
  not needed.
- Query Columns List: Grouping and aggregate icons in checkboxes are updated.
- Expression Editor: The Query Context panel content is generated correctly
  now.
- The NRE on the component disposal for some complex queries has been
  eliminated. 
- Query Columns List: The bug with displaying the 'Or' column before the
  'Criteria' column has been fixed.

June 23, 2021

Active Query Builder 3 WinForms Edition v.3.8.5.2202

- The bug with empty context lists in Expression Editor is fixed.
- The unhandled exception on opening Expression Editor has been eliminated.
- Visual glitches with the Expression Editor button in the Query Columns List
  were corrected.

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.

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