Downloads

Active Query Builder VCL Edition History

March 12, 2012

Active Query Builder VCL Edition v.1.18.11

= DevExpress UI: Design area and Select list use DevExpress scrollbars now.

March 07, 2012

Active Query Builder VCL Edition v.1.18.10

= Alias of a sub-query in expression is used now for sub-query tab caption.
- Localizer: Exception is not suppressed now on loading language from 
  non-existent file.
- Query is not cleared now on changing the QuoteAllIdentifiers and
  ObjectPrefixSkipping properties.
= The QueryStatistics.OutputColumns[i].ColumnName property value is always
  unquoted now.
- Oracle: Parsing of expressions like "expression IN expression" is fixed.
= MySQL: Parsing of logical expressions in criteria cells is fixed.
= English and Russian translations: rename "Edit..." to "Properties..."
- Other minor bug fixes are made.

February 03, 2012

Active Query Builder VCL Edition v.1.18.9

+ SQL 92, SQL 2003: Query Properties form is added to edit the DISTINCT clause.
= Now the double click on a datasource field appends it to the query column list
  but does not select it as output column.
- CTE datasources on hidden tabs are correctly resized now when on changing
  their field lists.
- PostgreSQL: Primary/foreign keys inversion is fixed.

January 20, 2012

Active Query Builder VCL Edition v.1.18.8

- The problem with loading fields for stored procedures is fixed.
= Firebird: The new aggregate LIST, WEEKDAY and YEARDAY keywords in EXTRACT
  function are added.
= "_xml_error" is renamed to "_xml_error_aqb" to fix the CBuilder msxml.hpp names
  conflict.

January 13, 2012

Active Query Builder VCL Edition v.1.18.7

= DevArt ODAC: Internal datasets are created uni-directional now.
+ MS SQL Server: FOR XML is supported in subqueries now.

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.