Downloads

Active Query Builder VCL Edition History

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 
  menu.

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.

September 12, 2013

Active Query Builder VCL Edition v.1.21.7

+ Query layout is now preserved after parsing of the modified query.
+ Algorithm of automatic objects placement on the diagram pane is improved.
= The OptionsView.SplitterResizeUpdate property now affects horizontal splitter.
  (between the Query Columns grid and the Design area)
- Small fixes for MSStyleGrouping mode are made.