Downloads

Active Query Builder VCL Edition History

January 10, 2012

Active Query Builder VCL Edition v.1.18.6

- Fixup and statistics (OutputColumns) for stored procedures is fixed.
- MS SQL, MySQL, PostgreSQL:  Loading of precision and scale for numeric fields 
  from server system catalogs is fixed.

December 29, 2011

Active Query Builder VCL Edition 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 19, 2011

Active Query Builder VCL Edition v.1.18.3

- Several fixes related to the FilterTabsByActiveQueryPart property are made.

December 13, 2011

Active Query Builder VCL Edition 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.

December 02, 2011

Active Query Builder VCL Edition v.1.18.1

+ The new property TacBaseSqlBuilder.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:
  acqpQuery (default): generate SQL text for the whole query;
  acqpSubQuery: generate text for the currently active sub-query tab;
  acqpUnionSubQuery: generate text for the currently active union sub-query.
+ TacBaseSqlBuilder.SQL propery become writable to apply changes in the
  currently active query part to the query builder.
+ The new TacQueryBuilder.FilterSubQueryTabsByActive 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 TacBaseSqlBuilder.TargetQueryPart.
+ The new TacQueryBuilder.OnQueryProcedureParameters event is added to override 
  the embedded dialog prompting for the stored procedure parameters.
- MySQL: Parsing of sub-queries in criteria cells is fixed.
- Loading of outer joins in WHERE is fixed.
- The link popup menu does not allow to create FULL OUTER joins for links in
  WHERE clause now.

December 01, 2011

Active Query Builder VCL Edition v.1.18.0

= AnyDAC: package name is corrected in order to comply with version 5.
= Advantage: package name for Delphi XE is corrected.
= Russian translation is updated.

November 21, 2011

Active Query Builder VCL Edition v.1.17.13

- Fixed: Aliases in ORDER BY are used for queries with unions only.
+ The SelectItem property is added to the QueryStatistics.OutputColumn's items.

November 07, 2011

Active Query Builder VCL Edition v.1.17.12

- Small memory leak is fixed.
- "Invalid pointer operation" error introduced in version 1.17.9 is fixed.

November 01, 2011

Active Query Builder VCL Edition v.1.17.11

+ Support of ORDER BY in queries with unions is improved.
+ Yet another bunch of speed optimizations is made.

October 28, 2011

Active Query Builder VCL Edition v.1.17.10

+ MS SQL Server: Support of variables as query datasources is made. 
  (select * from @variable)
+ MySQL: Parsing of nested functions is speeded up.
- Fixed bug with qualified names comparison introduced in the previous version.