Downloads

Active Query Builder 3 WinForms Edition History

July 04, 2018

Active Query Builder 3 WinForms Edition v.3.4.19.1100

- CriteriaBuilder: Boolean conditions loading has been fixed.

June 29, 2018

Active Query Builder 3 WinForms Edition v.3.4.19.1099

= The current active sub-query is saved now in the XML structure of the
  LayoutSQL property.

June 28, 2018

Active Query Builder 3 WinForms Edition v.3.4.19.1098

= Building the visual diagram for queries containing a large number of
  columns or when objects used in the query contain a large number of 
  fields has been significantly speeded up.
- The bug with the Design Pane control scrolling while dragging a field 
  over it has been fixed.
- The bug in the QueryTransformer with the WHERE clause corruption when 
  Skip/Take is set which arose on the SQL Server 2005 and 2008 has been
  fixed.

June 21, 2018

Active Query Builder 3 WinForms Edition v.3.4.18.1097

+ SAP HANA: Detection of the default schema has been made.
+ SQL Server Compact Edition: The list of functions and keywords has been
  filled.
= The "INTO"-related properties are hidden from the Properties bar now if 
  the SyntaxProvider.DenyIntoClause is set to True.

June 09, 2018

Active Query Builder 3 WinForms Edition v.3.4.17.1096

- Query Column List control now allows resizing of the "Grouping" column.
- The bug with primary key links menu item captions has been fixed.
- Captions of the "Or" columns are updated correctly now on changing the
  language.

June 08, 2018

Active Query Builder 3 WinForms Edition v.3.4.17.1095

+ Initial support for SAP HANA has been added: metadata retrieval queries, 
  list of built-in functions. 
= The BaseSyntaxProvider.BuiltinFunctionNames property is public now.
= The new helper method MetadataField.GetDataTypeName has been added to 
  get datatype string combining the ServerTypeName, Size and Precision
  attributes.
- Retrieval of referenced objects by foreign keys for unsupported servers
  has been speeded up.
- Hiding the information message when the reported problem is no longer 
  actual has been fixed.
- The original Metadata Structure is preserved now after searching to keep 
  the assigned event handlers.
- Minor scaling issues have been fixed.

May 29, 2018

Active Query Builder 3 WinForms Edition v.3.4.16.1094

- SQL Text Editor: The bug with building the suggestion list for metadata 
  with loaded linked servers has been fixed.
- Minor bug fixes have been fixed.

May 28, 2018

Active Query Builder 3 WinForms Edition v.3.4.16.1093

= References to DevExpress have been updated to v.18.1.
= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
- WinForms: Minor fixes and improvements for the Database Schema View have
  been made (Border style, multi-select).
- Teradata: The bug with autodetection of new versions has been fixed.

May 18, 2018

Active Query Builder 3 WinForms Edition v.3.4.15.1092

= Logging improvements have been made.
= Now trying to cut off garbage in the fields description while fetching
  metadata from ODBC driver. (a workaround for the bug in MS Access ODBC
  driver)
- The bug with side panels visibility has been fixed.

May 16, 2018

Active Query Builder 3 WinForms Edition v.3.4.14.1091

+ The new DataSourceAddLinkedObject event has been added to the
  QueryBuilder, QueryView objects to override the default behaviour on
  adding a new object to the query which is linked to the existing one.
+ The new DataSourceOptions.ShowOptionsButton property has been added.
  It allows hiding the Datasource Options (hamburger) button.
= Metadata loading: Field type doesn't get updated by the Metadata Provider
  now if it is already loaded (show type names instead of domain names).
- The Null Reference Exception when asterisk item is hidden has been fixed.
- The IAddObjectDialog.MetadataStructure property is now writeable.
- Add Object Dialog: The bug with displaying folders in the drop-down list
  has been fixed.
- DevExpress: Applying themes to the SQL Text Editor has been fixed.
- DevExpress: The bug with displaying the suggestion popup has been fixed.
= DevExpress: SqlTextEditor.BorderStyle property type has been changed from
  Windows.Forms.BorderStyle to DevExpress.XtraEditors.Controls.BorderStyles.

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