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.