Downloads

Active Query Builder WinForms Edition History

December 18, 2014

Active Query Builder WinForms Edition v.1.19.4.439

= DB2: Better compatibility with DB2 for mainframes

December 10, 2014

Active Query Builder WinForms Edition v.1.19.4.438

- MS SQL Azure: The "nullable" attribute loading fix is made.
- DB2: Fallback to QSYS2.SYSTABLES if SYSIBM.SYSTABLES does not exists is made
  (for older systems).
= DevExpress references are updated to v14.1.7.0.

September 19, 2014

Active Query Builder WinForms Edition v.1.19.4.437

- The NullReferenceException on dispose when using the component in 
  WPF WindowsFormsHost is fixed.
= DevExpress references are updated to v14.1.6.0.

November 28, 2013

Active Query Builder WinForms Edition v.1.19.4.434

= References to DevExpress controls are updated to v.13.1.8.0.
- Tab order in Datasource Properties form is fixed.
- Auto-detection of Teradata, MS SQL CE and Azure database servers is fixed.
- Loading of joins in WHERE clause with subqueries referencing other
  datasources is fixed.
- Check boxes painting at non-standard display resolution settings 
  (120 DPI and more) is fixed.
- Expression Editor: The bug with ShowSuggestionAfterCharCount property 
  causing problems in the Form designer is fixed.
- SQL Text Editor: Backward search from the end of text is fixed.
- Oracle: Keywords UNTIL and UPDATED can be used as identifiers.
- Oracle: Fixed MODEL clause.
- Oracle: Support for KEEP expression is added.
- Oracle: Parsing of PARTITON with OUTER JOIN is fixed.
- PostgreSQL: Support for AT TIME ZONE expression is made.
- PostgreSQL: Support for the ROW constructor expression is made.
- PostgreSQL: The EXTRACT function is fixed.
- PostgreSQL: Support for ORDER BY in aggregate functions is added.
- MS SQL Server: "PARSE" is valid identifier now.
- MS SQL Server: The conflict between "char", "nchar" identifiers and 
  same-named built-in functions is solved.
= MS SQL Server: Parsing of nested function calls is optimized for speed.

October 25, 2013

Active Query Builder WinForms Edition v.1.19.3.432

+ QueryTransformer now can hide output columns and set the DISTINCT clause.
= MS SQL Server: The query for loading foreign keys from server is improved.
- Oracle: Fixed unicode literals (N'abcdef').
- Oracle: Fixed parsing of the DENSE_RANK() function.
- PostgreSQL: Added support for multi-param aggregates.
- PostgreSQL: Fixed parsing of ANY in codition cells.

October 14, 2013

Active Query Builder WinForms Edition v.1.19.2.431

+ MS SQL Server: Support for CLR method calls is added.

September 24, 2013

Active Query Builder WinForms Edition v.1.19.2.428

! The OracleNativeMetadataProvider now refers to the new
  Oracle.ManagedDataAccess assembly instead of the Oracle.DataAccess ADO.NET
  provider.
- Oracle: Usage of the "TIMESTAMP" keyword as column name is possible now.
- The bug with incorrect bracketing of inner OR conditions is fixed.
= Dependencies for DB2, Informix, Firebird and MySQL ADO.NET providers are
  updated.
= DevExpress references are updated to v13.1.6.0.
= Source code examples are updated to use ACE drivers for MS Access database
  instead of Jet 4.

July 31, 2013

Active Query Builder WinForms Edition v.1.19.1.427

= DevExpress references are updated to v.13.1.5.0.
= Mixed-case alternate names now treated as mixed-case identifiers and quoted
  according to the server case sensitivity rules.
= MS SQL Server: Table hints syntax is updated according to the SQL Server 2012.
- MS SQL Server: The bug with INDEX() table hint is fixed.
- Memory leaks are eliminated.

July 23, 2013

Active Query Builder WinForms Edition v.1.19.0.426

- MS Access: Assertion failure on clearing a complex query is fixed.

July 11, 2013

Active Query Builder WinForms Edition v.1.19.0.425

- SQL Text Editor: The bug with cursor positioning after Backspace action 
  with enabled word wrapping is fixed.

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