Active Query Builder VCL Edition History

February 25, 2014

Active Query Builder VCL Edition v.1.22.8

+ Add Linked Objects menu: Separate menu items are shown now if there are many
  links for a linked object.
= FireDAC: Zero command timeout can be set now to turn off timing out.
= The AltNameCaseSensitive flag is added to all objects with alternate names.
- MS SQL Server: Parsing of method calls is fixed.

January 25, 2014

Active Query Builder VCL Edition v.1.22.7

= MySQL: The KEY_COLUMN_USAGE is not queried if server version is less than 5.0.
= Firebird: New builtin functions are supported.
= Firebird: Special syntax of TRIM is supported now.
- PostgreSql: Parser ambiguity in ROW expressions is eliminated.
- Focus is not moved to the QueryBuilder anymore on assigning query text to
  the SQL property.

December 19, 2013

Active Query Builder VCL Edition v.1.22.6

= Required stack size for SQL parsing is reduced.
= Custom popup menu is used for all Query Columns Grid cells now.
= The RightToLeft mode is turned off for expressions in the Query Columns Grid. 
- Minor localization updates are made.
- The bug with loading empty string from localization in non-unicode Delphi 
  versions is fixed.
= MS SQL Server: SQL parser is optimized to speed up parsing of deep nested
  function calls.
= MS SQL Server: PARSE is treated as valid identifier now.
- MS SQL Server: Server version autodetection is fixed.
= MS Access: Date/time builtin functions are supported.

November 14, 2013

Active Query Builder VCL Edition v.1.22.5

+ PostgreSQL: The WINDOW clause is supported now.
+ PostgreSQL: The ORDER BY clause in aggregate functions is supported now.
+ PostgreSQL: The ROW constructor expressions are supported now.
+ PostgreSQL: The AT TIME ZONE is supported, the EXTRACT function is updated.
= Linked Objects Menu: Linked object names are sorted alphabetically now.
- Loading of WHERE joins with subqueries referencing other datasources is fixed.

October 30, 2013

Active Query Builder VCL Edition v.1.22.4

- Access Violation in UnionSubQuery.AddObject in non-visual mode is eliminated.
= Sleep Mode and Focusing fixes are made.
= Oracle: Partition OUTER JOIN support is fixed.
= MS SQL Server: Loading of relations is speeded up on SQL Server 2005 and higher.

October 24, 2013

Active Query Builder VCL Edition v.1.22.3

- Installer: Support of Delphi 5 is restored.
+ Query Transformer now can hide output columns and set the DISTINCT clause.
+ Alias is printed before expression in the Query Structure Tree.
+ Oracle: National string literals are supported now.
= Oracle: DENSE_RANK in partition clause is supported.
= MS SQL Server: System views are used now to fetch foreign keys 
  (for SQL Server 2005 and newer).
= PostgreSQL: Support of multi-parameter aggregates is made.
- PostgreSQL: Parsing of the ANY clause in codition cells is fixed.
- Query Transformer: Incorrect SQL query generation when source query has 
  the ORDER BY statement is fixed.
- DevExpress: The bug with incorrect datasource position changing when 
  resizing a datasource with a large list of fields is fixed.

October 10, 2013

Active Query Builder VCL Edition v.1.22.2

= Minor improvements in the Add Linked Objects menu are made.
= TacQueryTransformer API has been changed to reflect changes in the .NET version.
= The bug with not storing the server version in those syntax providers that 
  aren't capable to detect version automatically is fixed.
= Default prefixes in object names are skipped now in the Add Linked Objects 

October 03, 2013

Active Query Builder VCL Edition v.1.22.1

+ FireDAC packages are added.
+ The new DesignPaneOptions property group is made. It contains properties to
  define spacing between datasource objects on the Design Pane.  
+ MS SQL Server: CLR method calls support is made.
= The linked objects button is placed on the panel now.
= French translation is updated.
= Delphi 5 support is fixed.
- Other bug fixes are made.

October 01, 2013

Active Query Builder VCL Edition v.1.22

+ RAD Studio XE5 is supported now.
+ The new button is now shown at the right of the focused datasource on Design
  pane to allow easy adding of linked objects to the query. 
  Use the TacQueryBuilder.DatasourceOptions.ShowLinkedObjectsButton property 
  to disable this functionality.
+ The new datasource context menu item is added for the same purpose.
- MS Access: Parsing of the ASC builtin function is fixed.

September 13, 2013

Active Query Builder VCL Edition v.1.21.8

= Layout: Horizontal interval between datasources is decreased to 40 px.

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