Downloads

Active Query Builder 3 WinForms Edition History

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.

September 13, 2017

Active Query Builder 3 WinForms Edition v.3.3.19.1065

+ The new StatisticsField.IsDirectlyMentioned property has been added. 
  It indicates whether a field is directly mentioned in the query or just
  appears in the query result as a result of the expansion of an asterisk
  item ("*") in the SELECT list.
= User queries structure has been moved from the UserQueries control to 
  the SQLContext.UserQueriesStructure property.
- SQL Text Editor: Word wrapping has been fixed.

August 25, 2017

Active Query Builder 3 WinForms Edition v.3.3.18.1065

+ MS SQL Server: Support for SELECT into local variable has been added.
  (SELECT @localVar = ...)
- The bug with resolving baseName.fieldName references for stored procedures
  and table-valued functions has been fixed.
- The bug with not refreshing fields for objects in the main query via 
  RefreshDatasourcesMetadata call has been fixed.
- The bug with not allowing to expand object type grouping nodes (Tables,
  Views, ...) in the Database Schema Tree has been fixed.

August 18, 2017

Active Query Builder 3 WinForms Edition v.3.3.17.1064

+ Text Editor: Oracle LISTAGG function template has been added. 
= StreamLog: The underlying stream is flushed now on every write. 
- CriteriaBuilder: Loading conditions with BETWEEN operator for datetime
  columns has been fixed. 
- PostgreSQL: Autodetection has been fixed in the Auto Syntax Provider. 
- Syntax detection process is logged now in the Auto Syntax Provider.

August 11, 2017

Active Query Builder 3 WinForms Edition v.3.3.16.1063

+ The new IDatabaseSchemaView.ValidateItemContextMenu event has been made.
  It lets customize context menu of the Database Schema Tree items. 
+ The new IDatabaseSchemaView.ExpandItem has been made to expand the tree
  down to the specified item and scroll down to it.
+ Position of an invalid object can be obtained from the SQLParsingException
  on parsing a query when ParsingErrorOnUnknownObjects property is set to
  True.
- MetadataLoadingOptions.IncludeFilter/ExcludeFilter: filtration by object
  type only has been fixed.
- SQL Text Editor: Apostrophes in quoted identifiers don't break the 
  highlighting now.
- The QueryBuilder.LayoutSQL property now accept empty strings without
  errors.
- Correct column prefix now emitted for UDFs and stored procedures
  without aliases.

July 25, 2017

Active Query Builder 3 WinForms Edition v.3.3.15.1063

+ The new IDatabaseSchemaView.ValidateItemContextMenu event has been added
  to allow the creation of custom context menu for items in the Database 
  Schema Tree.

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