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
= 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,
- 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
+ Advantage metadata provider is fixed. It's now can be used to work with DBF
= 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.

Product Summary

 Active Query Builder WinForms .NET Edition:

 Active Query Builder WPF .NET Edition:

 Active Query Builder ASP.NET Edition:

 Active Query Builder Java Edition:

 Active Query Builder ActiveX Edition:

 Active Query Builder VCL Edition:



We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks