Downloads  »  Active Query Builder VCL Edition History

May 22, 2020

Active Query Builder VCL Edition v.1.30.3

Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.30.3.

= Design Pane: Datasource captions are made more contrast.
= Usability of building queries with grouping has been improved by a series
  of small fixes.
+ The new property QueryBuilder.SwapSidePanels has been added to swap the 
  Database Schema Tree and the Query Structure Tree.
- SQL Text Editor: Minor fixes and improvements for the suggestions list
  have been made.
= SQL Text Editor: The new property SqlTextEditorOptions.SyncSuggestionLoading
  has been made for DACs having problems with running queries in threads.
+ Oracle: params and fields for stored procs, table functions loading fix
= Oracle: Synonyms are loaded faster now.
- Oracle: The bug in the QueryTransformer that led to incorrect query 
  generation has been fixed.
- SQL Server: Loading field comments for objects from non-default schemas 
  and databases has been fixed.
+ PostgreSQL: Support for the WINDOW, FILTER clauses has been added.
+ SQLite: Support for the WINDOW and FILTER clauses and analytic expressions
  has been added.
= SQLite, Teradata: Support for the REPLACE function has been fixed.
= SAP Hana: Support for TOP and PLACEHOLDER clauses, NVARCHAR builtin type,
  CURRENT_UTC* constants have been added.
+ SAP Hana: Metadata filters are applied now to metadata fetching queries.
- SAP Hana: Working with table functions has been fixed.
= Nexus DB: Support for the TOP clause has been added.
= Nexus DB: QueryTransformer now supports Skip and Take methods.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder VCL Edition at the download page.

» Full Active Query Builder VCL Edition history