Downloads

Active Query Builder 2 ASP.NET Edition History

December 01, 2020

Active Query Builder 2 ASP.NET Edition v.2.14.4

= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- Oracle: The bug with parsing names containing the PACKAGE component is
  fixed.
- MySQL: The bug with the special syntax of POSITION has been fixed.

February 08, 2019

Active Query Builder 2 ASP.NET Edition v.2.14.3

+ MySQL: Support for Common Table Expressions in MySQL 8+ has been made.
- PostgreSQL: Parsing of the AT TIME ZONE operator has been fixed.
- MS Access: The bug with TRUE and FALSE constants parsing has been fixed.
- Oracle: The bug with columns for objects from linked DBs has been fixed.
- PostgreSQL: Parsing ambiguities for INTERVAL and AT TIME ZONE have been
  eliminated. 
= MS SQL Server: Column aliases for functions are allowed now.
- The bug with loading queries having ordering by indexes and an asterisk 
  in the SELECT list has been fixed.
+ Oracle: Support for ranking functions has been improved.
= Loading of fields with data type unsupported by a database driver is made
  more reliably now.
- PostgreSQL: Parsing of "EXTRACT(epoch FROM ...)" function has been fixed.

June 22, 2018

Active Query Builder 2 ASP.NET Edition v.2.14.2

= Numeric constants in ORDER BY are converted to corresponding expressions
  now.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.
+ Oracle: Loading of stored procedure parameters from the server system
  catalog is supported now.
= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
- Teradata: The bug with autodetection of new versions has been fixed.
- SQLite: Parsing of queries with RIGHT and FULL joins now results in the 
  parsing error.
- MS SQL Server: Parsing of qualified names with skipped components has been
  fixed.
- MS SQL Server: Loading of fields for linked servers without database or 
  schema has been fixed.
= PostgreSQL parser has been optimized.
= SQLite: Keywords list has been filled.
- MySQL: Support of STDDEV function has been fixed.
+ Sybase: Support for window functions has been added.
- DB2: NULL is parsed now as a constant, not as an identifier.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and 
  OPTIMIZE FOR in an arbitrary order has been fixed.

November 30, 2017

Active Query Builder 2 ASP.NET Edition v.2.14.1

+ Batch loading of fields and foreign keys for Oracle, MS SQL Server and 
  DB2 has been implemented.
+ The new SyntaxProvider.UseBatchMetadataLoading property has been added
  (default: True).
- Criteria Builder: The bug with "between" operator for date fields has 
  been fixed.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Query Transformer: Applying both pagination and sort order has been fixed.

October 03, 2017

Active Query Builder 2 ASP.NET Edition v.2.14.0

- Minor link drawing glitches have been fixed.
- Client-side programmatic query creation API with aggregates and grouping
  has been fixed.
+ PostgreSQL: Support for "$n"-style positional parameters has been added.
- Oracle: List of keywords used as valid identifiers has been updated.
- MySQL: Some valid identifiers were erroneously treated as keywords. 
  Fixed now.

September 15, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.16

+ MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions 
  has been added.
= Internal HTTP session optimizations have been made.

September 06, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.15

+ The new QB.Web.Core.Events.SyncFinished event has been added. It's fired
  when the sync action is completed and data from the server is applied to
  controls.
+ The new QB.Web.Core.unbind(event, callback) method has been added. It
  allows unsubscribing the given handler from an event.
= The QB.Web.Core.updateSQL method now puts the SQL query text to the 
  editor.
+ 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.

August 18, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.14

- The Edit Sub-query icon wasn't shown for Common Table Expressions. Fixed
  now.
- Displaying the structure of complex queries in the Sub-query navigation
  bar has been corrected.
- The bug in Criteria Builder with setting "is between" operator for date
  fields has been fixed.
- MetadataLoadingOptions.IncludeFilter/ExcludeFilter: filtration by object
  type only has been fixed.
- The QueryBuilder.LayoutSQL property now accepts empty strings without
  errors.
- Correct column prefix now emitted for UDFs and stored procedures without
  aliases.

July 14, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.13

- The bug with resizing of datasource on Design Pane has been fixed.
= Diagnostic error message is now shown if there's no access to the session
  store.
= MS SQL Server: List of keywords has been updated.

July 04, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.12

- The CopyLocal property is now set to True for all references to Active 
  Query Builder properties in the demo projects.
- The bug with loading of multiple unnamed foreign keys has been fixed.