Downloads

Active Query Builder 2 WinForms Edition History

October 14, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.792

+ Aggregate and builtin functions list is cached now to speed up large 
  query text generation.
= MetadataItem: InvalidOperationException is thrown now if both 
  MetadataName and MetadataItem property values are specified.
= UnionSubQuery.AddDatasource*At method: if any of the drop coordinates
  is negative, drop position is calculated automatically. Note that this
  method treats given coordinates as absolute screen coordinates.
- MS SQL Server: CHAR(n) parser ambiguity is fixed.
- MS SQL Server: ROW and ROWS are added to the list of valid identifiers.

September 23, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.790

+ PostgreSQL: Support for custom aggregate functions is added.
- Query Transformer: The bug with incorrect generation of the ORDER BY
  clause if column alias is same as field name is fixed.
- MS SQL Server: CHAR and NCHAR are added to the list of valid identifiers.
- Query Structure Tree flickering on batch query items processing is
  eliminated.
- The bug with getting empty nodes on copying Database Schema Tree to
  another control is fixed.

September 07, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.788

- PostgreSQL: Date/time parts are added to the list of valid identifiers.
- PostgreSQL: Parsing of set operators is fixed.

August 24, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.786

- The bug with aggregate functions with an asterisk parameter ("*") is fixed.

August 15, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.785

+ Criteria Builder: BETWEEN operator is available for string values now.
= DevExpress references are updated to v.16.1.5.

July 25, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.783

- PostgreSQL: User-defined prefix operator precendence fix.
- The bug with incorrect determination of datasource on Design Pane for 
  aggregated columns is fixed.

July 13, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.782

= QueryColumnsListOptions.UseCustomExpressionBuilder: enabled for all columns
  by default.
- Obey syntax.IsSupportGroupByAlias even for queryies with unions.
- MS SQL Server: New DatePart items are added (ISO_WEEK, TZOffset, ...)
- Informix: Builtin funtions support: YEAR, ... is made.

July 01, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.781

+ Query Builder now tries to fix invalid aliases on loading a query.
= DevExpress references are updated to v.15.2.9.
- The UnionSubQuery.Remove method is fixed.
- The bug in MSSQLStyleGrouping mode is fixed.

April 21, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.777

+ Oracle: database links are supported now.
= MS SQL Server: Parsing speed is improved.
- DB2: The query to load Primary Key flag for fields is fixed.
= MetadataForeignKey.ReferencedObject works with alternate names now.
- Query Columns List Control: Copying existing expression and pasting 
  it to a new row is fixed. 
- MS SQL: Loading additional information about fields from non-default
  databases is fixed.

April 04, 2016

Active Query Builder 2 WinForms Edition v.2.10.5.773

= Metadata retrieval from Sybase IQ works fine now.
- Metadata Filter: correct behaviour on filterItem.Exclude set
- Cross thread error in the Quick Search box of Database Schema View is
  fixed.
- MS SQL Server: Fetching stored procedure parameters from system catalog 
  is fixed.
- DB2: Fetching description for synonyms is fixed.
- Teradata: Fields are sorted by default by ColumnId.

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