Downloads

Active Query Builder History History

December 13, 2019

Active Query Builder History v.3.5.33.1150

= The new helper method QueryColumnListItem.CreateAliasIdentifier has been 
  added to get a column name from the alias.
- The Null Reference Exception on loading OR conditions with brackets has
  been eliminated.
- Auto Syntax Provider: The Null Reference Exception on disposing of
  referencing objects has been fixed.
- Quotation of aliases and other identifiers with alternate quotation
  symbols has been corrected.
- The bug with adding HAVING conditions using the
  QueryColumnList.AddCondition helper has been fixed.

December 13, 2019

Active Query Builder History v.3.5.33.1150

= The new helper method QueryColumnListItem.CreateAliasIdentifier has been 
  added to get a column name from the alias.
- The Null Reference Exception on loading OR conditions with brackets has
  been eliminated.
- Auto Syntax Provider: The Null Reference Exception on disposing of
  referencing objects has been fixed.
- Quotation of aliases and other identifiers with alternate quotation
  symbols has been corrected.
- The bug with adding HAVING conditions using the
  QueryColumnList.AddCondition helper has been fixed.

December 13, 2019

Active Query Builder History v.3.5.33.1150

= The new helper method QueryColumnListItem.CreateAliasIdentifier has been 
  added to get a column name from the alias.
- Query Column List: The 'Sort Order' column name has been corrected.
- The Null Reference Exception on loading OR conditions with brackets has
  been eliminated.
- Auto Syntax Provider: The Null Reference Exception on disposing of
  referencing objects has been fixed.
- Quotation of aliases and other identifiers with alternate quotation
  symbols has been corrected.
- The bug with adding HAVING conditions using the
  QueryColumnList.AddCondition helper has been fixed.

December 13, 2019

Active Query Builder History v.1.30.0

Standard edition:
+ The new component TacSQLScript splits the query by statements, allows to 
  look through them and edit separate statements in it.
+ The new TacQueryParametersTransformer component is added to: 
  1. cut off conditions with undefined parameter values, 
  2. convert parameter notation to the colon-prefixed notation.
= Query Columns List: Handling of incomplete strings in expression cells 
  has been improved.
- PostgreSQL: Support for WITH clause in subqueries has been added.

Professional version:
+ The new TacQueryParametersTransformer is also capable to deal with macros.
  Using it you can replace a single parameter with a list of values, SQL 
  expression or sub-query. 
+ SQL Text Editor: The suggestion list now works smoothly, filters items to
  suggest smarter and loads the needed metadata in a thread. 
+ SQL Text Editor: New properties have been added to tune colors and 
  suggestion behavior.
+ SQL Text Editor: Highlights the current SQL statement and provides methods
  to get and set the current SQL statement.
= SQL Text Editor: Other fixes and usability improvements have been made.

December 13, 2019

Active Query Builder History v.1.30.0

+ Now you can assign an SQL script with DECLARE and SET statements preceding 
  the SELECT query to the ActiveQueryBuilderX.FormattedSQL property.
  The component will bypass statements preceding the first SELECT statement,
  lets you edit the SELECT statement and get back the script with the 
  preceding statement and the modified SELECT statement.
+ The new properties ActiveQueryBuilderX.ParameterValues* are made to: 
  1. cut off conditions with undefined parameter values, 
  2. apply parameter values (scalar and lists where it's possible),
  3. replace parameters with SQL expressions in the query text.
= Query Columns List: Handling of incomplete strings in expression cells 
  has been improved.
- PostgreSQL: Support for WITH clause in subqueries has been added.

November 25, 2019

Active Query Builder History v.3.4.8.10

- NRE in the GridRowDtoFactory introduced in the previous version has 
  been fixed.

November 22, 2019

Active Query Builder History v.3.5.32.1149

= New helper method has been made to add conditions to WHERE or HAVING:
  UnionSubQuery.QueryColumnList.AddCondition(ConditionType conditionType, 
  string condition).
- PostgreSQL: Support for WITH clause in subqueries has been added.
- MS SQL Server: Parsing of ordinal named parameters ("@0") has been restored.

November 22, 2019

Active Query Builder History v.3.5.32.1149

= Query Columns List: Handling of incomplete strings in expression cells has 
  been improved.
= The missing method ISqlTextEditor.GetOffsetFromPoint has been restored.
= New helper method has been made to add conditions to WHERE or HAVING:
  UnionSubQuery.QueryColumnList.AddCondition(ConditionType conditionType, 
  string condition).
- PostgreSQL: Support for WITH clause in subqueries has been added.
- MS SQL Server: Parsing of ordinal named parameters ("@0") has been restored.

November 22, 2019

Active Query Builder History v.3.5.32.1149

= References to DevExpress assemblies have been updated to version 19.2.
= Query Columns List: Handling of incomplete strings in expression cells has 
  been improved.
= The missing method ISqlTextEditor.GetOffsetFromPoint has been restored.
= New helper method has been made to add conditions to WHERE or HAVING:
  UnionSubQuery.QueryColumnList.AddCondition(ConditionType conditionType, 
  string condition).
- PostgreSQL: Support for WITH clause in subqueries has been added.
- MS SQL Server: Parsing of ordinal named parameters ("@0") has been restored.
- DevExpress: DatabaseSchemaTree nodes expansion has been fixed.

November 22, 2019

Active Query Builder History v.3.4.8.9

+ The new AQB.Web.QueryBuilder.GridOnRowRemoving event has been added.
= All client-side "ing"-suffixed AQB.Web.QueryBuilder events have got 
  the abort parameter to deny the user-initiated change.
- The bug with not updating the Properties panel in rare cases has been fixed.