Downloads

Active Query Builder VCL Edition History

October 26, 2011

Active Query Builder VCL Edition v.1.17.9

+ Parsing and working with large queries is speeded up.
+ PostgreSQL: list of builtin functions is added.
+ IBM DB2: The new TacDB2SyntaxProvider.NamingConvention property is added. It 
  allows to change the delimiter that split parts in fully qualified object names.
  Available values: db2ncSql (dot), db2ncSystem (slash).

October 11, 2011

Active Query Builder VCL Edition v.1.17.8

= Ordering for the query column is removed now when grouping become unchecked;
  grouping is checked when ordering added.
= Grouping is turned on for the query column when user indicates it's conditions
  to be appled for groups (i.e. to the HAVING clause).
= MS SQL Server: "FOR XML" clause is updated to support Ms Sql Server "Denali".
= MySQL: COALESCE, GREATEST, LEAST and INTERVAL added to the list of builtin
  functions.
= PostgreSQL: Function "substring('test',1,2)" is converted to "substring('test'
  from 1 for 2)" on parsing the query.
= Firebird: INT type alias is supported.
- AV when editing the query columns list in rare cases is fixed.
- Assignment of unnecessary aliases for expressions in rare cases is fixed.

September 02, 2011

Active Query Builder VCL Edition v.1.17.7

= QueryStatistics.OutputColumns.ExpressionAlias is now unquoted.
= Conditions aren't turned to HAVING automatically for grouped query columns.
+ The new methods are added to ease the query analysis and modifcation: 
  TacQueryBuilder.GetSubQueriesList and GetUnionSubQueriesList,
  TacUnionGroup.GetUnionSubQueriesList.
- Oracle: TRANSLATE function is fixed.

August 25, 2011

Active Query Builder VCL Edition v.1.17.6

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
= Now using DevExpress PageControl v3 by default.
= DevExpress controls package names are corrected.
- Adding objects with same AltName from the database objects tree is fixed.

August 23, 2011

Active Query Builder VCL Edition v.1.17.5

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
- MySQL: Reversed displaying of foreign key relationships is fixed.
- Exception is not raised now if the OleInitialize call is failed. 
  It's necessary for OLE drag'n'drop functionality.
- PostgreSQL: Parsing of SUBSTRING function and ARRAY literals is made.
= The new TacQueryBuilder.RefreshDatasourcesMetadata function is made. It is
  needed to allow metadata refreshing without reloading of the current SQL text.

August 11, 2011

Active Query Builder VCL Edition v.1.17.3

+ Support of DevExpress VCL controls v2011 vol.1.5 is made.
- Localizer: Localization of TStrings is fixed.

July 17, 2011

Active Query Builder VCL Edition v.1.17.2

+ The new method is added to TacUnionSubQuery:
  ConvertDatasourceToDerivedTable(ADatasource): TacDatasourceQuery
+ TacUnionSubQuery: The new Clear method and SQL property (read-write)
  are added. Now you can modify the sub-query text separately.
+ The new TacDatasource.NameInQuery read-only property is added. 
  It allows to get datasource name as it should be referenced in the query.
= MS SQL: Loading objects from linked servers is restored.
= MySQL: Parsing of the ORDER BY clause is improved.
- Mimer Sql: Reference type is not supported by MimerSql. Fixed now.
- Alignment in UnionNavBar is suspended when updating the union buttons to
  prevent flickering.
- NexusDB 3 metadata provider compilation is fixed.
- AV on creating link by identical field names is fixed.

June 08, 2011

Active Query Builder VCL Edition v.1.17.1

+ MS SQL Server: Table and query hints are supported; join hints are parsed
  fine now, but not preserved due to architecture limitations.
+ TacMetadataRelation: Setters for ChildTable and ChildTableStr properties
  are made.
- SQLite: Parsing of sub-queries in condition cells is fixed.
- German translation: Wrong translation "Default"->"German" is reverted to
  "Default".
+ Advantage metadata provider is fixed. It's now can be used to work with DBF
  files.
= Firing the OnLinkCreating and OnLinkCreated events in AddFKLinksForObject and
  AddIdenticalFieldsLinksForObject methods is made.
= MySQL: UNSIGNED is treated as a valid data type now.

May 19, 2011

Active Query Builder VCL Edition v.1.17.0

+ The new TacQueryBuilder.OnActiveUnionSubQueryChanged event is added.
+ SQL queries that look like "select orders.orderId from orders o" are fixed
  now to "select o.orderId from orders o".
= Grouping is set automatically now on specifying the aggregate for a column.
= The "=TRUE" condition is set automatically on adding a logical expression now.
= The numbers entered into condition for string fields are treated as literals.
= MySQL Query Properties form is redesigned.
+ MySQL: The [Default|DISTICTS|ALL] query options are added to the Query 
  Properties dialog.
- MS SQL Server: Fetching metadata object descriptions from database is made.
- Metadata refreshing for derived tables is fixed.
- Oracle: The TRANSLATE function and CAST-MULTISET-AS clause are fixed.
- Minor bugs on reomving CTE from query are fixed.

May 12, 2011

Active Query Builder VCL Edition v.1.16.22

= Support of DevExpress ver.56 is made. (Package name renamings were made)
+ The new method TacUnionSubQuery.AddLinksFromExpression() is added for manual
  adding of links with complex joining expressions.
- Fixed problem when a link was attached to wrong datasource on the design pane 
  in some rare conditions.
+ Metadata fetching support for NexusDB 3 is made.
- PostgreSQL: Parsing of logical expressions in criteria cells is fixed.
- Localizer: Loading of milti-line translated strings is fixed.
= Oracle: The GetSchemasListOracle procedure returns only schemas which have
  accessible database objects now.
= The Select checkbox is checked automatically now on adding a new expression.