Downloads

Active Query Builder History History

January 26, 2015

Active Query Builder History v.1.8.0.1150

+ The new property is/setResolveColumnNamingConflictsAutomatically() is added
  to instruct the component to generate unique aliases for explicitly specified
  query columns to avoid duplicated column names.
+ The new property 
  CriteriaListOptions.is/setCreateColumnAliasesForUnnamedColumns() is added 
  to instruct the component to add aliases for unnamed fields 
  (expressions, aggregates) automatically.
= Recursion loop detection on building result SQL with virtual fields is made.
- Missing record is added for metadata object's alternate name in XML form of 
  query structure (QueryBuilder.QueryStatistics.QueryStructureXML).
- The bug with improper virtual objects alias expanding in column references 
  is fixed.
- Metadata comments fetching is fixed.
= All query parameter types are enabled now for all syntaxes.
= Informix: Syntax auto-detection and table list loading is improved.
= QueryColumnListControl now commits changes when you getting the 
  QueryBuilder.SQL property.
= The Linked Objects menu now shows "No linked objects" item if no linked 
  objects are found.
- Datasource references to metadata objects are always refreshed when setting 
  the SQL.
= Identifiers quotation in data source captions is removed.
- Parsing of long qualified names for some SQL syntaxes is fixed.
- Oracle: Loading of schemas containing no tables is fixed.
- Oracle: Metadata loading performance is improved.
= Oracle: Expression parsing optimisation is made.
- Oracle: Parsing of the REFERENCE keyword is fixed.
+ Oracle: The SEARCH and CYCLE clauses are now supported in CTE sub-queries.
- Oracle: Loading of foreign keys and user aggregates by unprivileged user is
  fixed.
- Firebird: Support for the WEEK date part is made.
- MySQL: Support for quoted characters in string literals is made.
- PostgreSQL: Parsing of common table expressions (CTE) is fixed.
= PostgreSQL: Parsing of ROW clause is improved.
- PostgreSQL: Support for RECURSIVE keyword in WITH clause is added.
+ MS SQL Server: New SQL Server 2012 analytic functions are added.
+ MS SQL Server: Support for IIF function and WITHIN GROUP clause is added.
- MS SQL Server: Parsing of function calls is fixed.
- MS SQL Server: Mistyped DATETIMEOFFSETFROMPARTS name is fixed.
- MS SQL Server Compact Edition: Version detection is fixed.
- MS Access: Query Builder now accepts identifiers quoted with backticks 
  and convert backticks to square brackets.
+ SQLite: Support for Common Table Expressions (CTE) is made.
+ SQLite: Support for backtick-quoted identifiers is made.

January 22, 2015

Active Query Builder History v.2.7.1

= Parameters entered into the Criteria cells aren't quoted now.

January 21, 2015

Active Query Builder History v.1.24.9

= Scanner performance optimizations are made.

January 21, 2015

Active Query Builder History v.1.24.9

- Component usage under the Win64 platform is fixed. 
= Scanner performance optimizations are made.

January 19, 2015

Active Query Builder History v.2.7.0

+ The component is now compatible with jQuery 2.0.
- Switching to main query after adding union into derived table is fixed.
= Link for log4net and Json.NET to Nuget repositories is made.

January 16, 2015

Active Query Builder History v.1.7.3.1146

- MS SQL Server: Expressions parsing is fixed.

January 02, 2015

Active Query Builder History v.2.6.8

+ The new QueryBuilderControl.SuppressConfigurationWarning property is added.

December 25, 2014

Active Query Builder History v.2.6.7

- Sort mode in the Database Schema Tree is set to NameExceptFields by default.
- Possible exception in the GetHandlerPathFromWebConfig method is fixed.
- Fixes for DB2 mainframe and MS SQL Azure databases are made.

December 19, 2014

Active Query Builder History v.1.24.8

= DB2: The query to load default schema is corrected for older mainframes.
= DB2: Metadata objects loading is improved for older mainframes: fallback
  to QSYS2.SYSTABLES is made.
- Loading join conditions with references to objects from parent query 
  is fixed.
- Loading FROM clause enclosed with parenthesis is fixed.
- Memory leak is fixed.

December 19, 2014

Active Query Builder History v.1.24.8

= DB2: The query to load default schema is corrected for older mainframes.
= DB2: Metadata objects loading is improved for older mainframes: fallback
  to QSYS2.SYSTABLES is made.
- Loading join conditions with references to objects from parent query 
  is fixed.
- Loading FROM clause enclosed with parenthesis is fixed.
- Memory leak is fixed.