Active Query Builder WinForms Edition History

March 11, 2013

Active Query Builder WinForms Edition v.

+ The new properties are added to StatisticsOutputColumns class: DataSource,
  ObjectNameInQuery, ColumnNameInQuery.
- Oracle: Ambiguity in parsing of qualified column name with method call is
- Oracle: Support for named parameters in function call is made.
- PostgreSQL: Quoting problem with some date time and system functions like
  CURRENT_DATE or USER is fixed.
= DevExpress controls: Tree controls now select a node on expand to prevent 
  the tree to scroll out if previously selected node is out of visible area.

February 18, 2013

Active Query Builder WinForms Edition v.

SQL Text Editor changes:
+ Tab and Shift-Tab hot keys now shift the selected text block left and right.
- Mouse and keyboard selection behavior is fixed.
- Incorrect suggestion window placement when the text is scrolled right or the
  caret is near to the right bound of the screen is fixed.
- Text selection was disappearing on undo/redo operations. Fixed now.
- Painting of sequence of Tab characters in selected state is fixed.

Other changes:
- Oracle: Support for method call expressions is made.
- Loading of queries containing multiple use of the same table is fixed.

January 30, 2013

Active Query Builder WinForms Edition v.

- Teradata: Numerous fixes and improvements are made.

January 29, 2013

Active Query Builder WinForms Edition v.

= DevExpress references are updated to v.
= Conditions like "a > 1 and a < 3" now loaded into the same criteria cell.
= SQL Text Editor: "GROUP BY" and "ORDER BY" clauses are added to the suggestion 
  list as templates so they might be entered at one click.
- SQL Text Editor: Auto-capitalization of multi-word clauses that were added
  from suggestion list is fixed.
- SQL Text Editor: The problem with transfer of input focus when using the Tab
  key to move out of the editor is fixed.
- SQL Text Editor: The Find dialog was not disposed with the parent component.
  Fixed now.
- SQL Text Editor: Reaction on selected text clicking is changed.

December 26, 2012

Active Query Builder WinForms Edition v.

+ Support for Teradata Database is added. Use the new TeradataSyntaxProvider
  to build and parse queries for this database. Use the UniversalMetadataProvider
  to work with native ADO.NET provider, use OLE DB or ODBC metadata providers
  to connect via respective drivers.

December 17, 2012

Active Query Builder WinForms Edition v.

- MySQL: A workaround for known MySQL Connector/ODBC bug is implemented.

December 11, 2012

Active Query Builder WinForms Edition v.

- The SQLTextEditor.AutoInsertPairs property is fixed.

December 10, 2012

Active Query Builder WinForms Edition v.

- Sometimes the LayoutSQL property might save negative coordinates 
  of objects on the Design Pane, and incorrectly restore them. Fixed now.

November 30, 2012

Active Query Builder WinForms Edition v.

- MS SQL Server: The "Path" word could not be used as identifier. Fixed now.
= MS SQL Server Compact Edition: SQL CE dependency is updated to version
= Source code of MSSQLCEMetadataProvider is included in the installation

November 27, 2012

Active Query Builder WinForms Edition v.

- Oracle: Fixed ANY, ALL and SOME keywords in comparison expressions.

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:




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