Downloads

Active Query Builder History History

December 29, 2011

Active Query Builder History v.1.18.5

+ The new properties were added for more customizable SQL query text formatting:
  TSQLBuilderFromClauseFormat: NewLineBeforeComma, NewLineBeforeJoinExpression;
  TSQLBuilderItemsListFormat (formats SELECT list, GROUP BY and ORDER BY items):
  NewLineBeforeComma;
  TSQLBuilderPlainText.DynamicIndents: allows to indent the next item in the
  list to the same position as the first item;
  TSQLBuilderPlainText.DynamicRightMargin: instructs the component not to take
  into account leading spaces when counting line lenght to wrap.
- A memory leak when loading join conditions enclosed in parentheses is fixed.

December 23, 2011

Active Query Builder History v.1.16.0.341

- The locale-specific bug in SQLBuilder and parsers is fixed.
= DevExpress dependencies are updated to DevExpressControlFactory v.11.2.6.0.

December 21, 2011

Active Query Builder History v.1.5.1.1105

- DB2: The bug with EXISTS clause parsing is fixed.

December 21, 2011

Active Query Builder History v.1.16.0.340

+ The "+" button is added to the Union Navigation Bar to ease addition of new
  unions.

December 19, 2011

Active Query Builder History v.1.18.3

- Several fixes related to the FilterTabsByActiveQueryPart property are made.

December 19, 2011

Active Query Builder History v.1.18.3

- Several fixes related to the FilterTabsByActiveQueryPart property are made.

December 16, 2011

Active Query Builder History v.1.16.0.339

+ The new property PlainTextSQLBuilder.TargetQueryPart is added. It allows you
  to generate the SQL query text not for the whole query, but for active part 
  of the query only. Possible values are the following:
  Query (default): generate SQL text for the whole query;
  SubQuery: generate text for the currently active sub-query tab;
  UnionSubQuery: generate text for the currently active union sub-query.
+ PlainTextSQLBuilder.SQL property become writable to apply changes in the
  currently active query part to the query builder.
+ The new QueryBuilder.FilterTabsByActiveQueryPart property is added. It
  allows to hide the tabs that do not belong to the currently active query part.
  Possible values are the same as for the PlainTextSQLBuilder.TargetQueryPart.
+ The new source code sample "Show Query By Parts" is added to demonstrate 
  the new features.

December 16, 2011

Active Query Builder History v.1.5.1.1104

+ The new property PlainTextSQLBuilder.get/setTargetQueryPart is added. 
  It allows you to generate the SQL query text not for the whole query, 
  but for active part of the query only. Possible values are the following:
  Query (default): generate SQL text for the whole query;
  SubQuery: generate text for the currently active sub-query tab;
  UnionSubQuery: generate text for the currently active union sub-query.
+ PlainTextSQLBuilder.get/setSQL property become writable to apply changes in
  the currently active query part to the query builder.
+ The new QueryBuilder.get/setFilterTabsByActiveQueryPart property is added. It
  allows to hide the tabs that do not belong to the currently active query part.
  Possible values are the same as for the PlainTextSQLBuilder.TargetQueryPart.

December 13, 2011

Active Query Builder History v.1.18.2

+ CTE sub-queries are filtered properly now on setting such filtration with the
  FilterTabsByActiveQueryPart property.

December 13, 2011

Active Query Builder History v.1.18.2

+ CTE sub-queries are filtered properly now on setting such filtration with the
  FilterTabsByActiveQueryPart property.
+ The new TacLink.LinkExpressionString property is added to specify complex
  joining expressions programmatically.
- Minor bug fixes for the Link properties are made.