Active Query Builder VCL Edition History

August 18, 2017

Active Query Builder VCL Edition v.1.27.10

+ The new TacQueryBuilder.SelectListOptions.DropdownInExpressionColumn
  property has been added. Turn it off to hide the drop-down list in 
  the Expression column of the Query Columns Grid.
- Localization of TacCriteriaBuilder has been fixed.
- Installer: Folder for the demo projects can be changed now.

August 15, 2017

Active Query Builder VCL Edition v.1.27.9

- SQL Text Editor: Localization of the Find & Replace form has been made.
- Localization fixes in the Properties forms have been made.
- Correct column prefix is emitted for procedures and table-valued functions.
- Minor memory leaks have been eliminated.

August 02, 2017

Active Query Builder VCL Edition v.1.27.8

= Icons in the Union Navigation Bar and Query Columns List control are 
  correctly scaled now on High DPI monitors.
= FireDAC: Metadata filters are now applied on loading objects from driver.
- Professional: Source code compilation with DevExpress controls has been

August 01, 2017

Active Query Builder VCL Edition v.1.27.7

! Demo projects are installed now to the All Users Profile directory:
- Source code in Professional version has correct compiler defines now.
- Installer: An option to extract packages for all supported Delphi 
  versions has been made.
- SQL Text Editor: A memory leak has been fixed.
- SQL Text Editor: Font is scaled correctly now on high resolutions.
= The SQLTextEditor.ParentFont property has been made public.

July 28, 2017

Active Query Builder VCL Edition v.1.27.6

- Expression Editor: Access violation on moving mouse over the query objects
  tree has been eliminated.

July 27, 2017

Active Query Builder VCL Edition v.1.27.5

+ Professional: SQL Text Editor: packages for RAD Studio XE have been added.
+ Professional: Expression Editor: The new properties Height and Width
  determine the dialog size.
+ Professional: SQL Text Editor: Font scaling has been made.
- Professional: Expression Editor: Access Violation on mouse move over 
  metadata tree has been fixed.
= Various fixes and improvements in the Full-featured demo have been made.

July 22, 2017

Active Query Builder VCL Edition v.1.27.4

- Compilation errors for C++Builder have been fixed.
- Minor fixes for the Full-featured demo project have been made.
! Demo projects are moved to the %ALLUSERSPROFILE%\Documents\ActiveDbSoft\Demos"
  folder (usually "C:\Users\Public\Documents\ActiveDBSoft\Demos".

July 20, 2017

Active Query Builder VCL Edition v.1.27.3

+ The new Professional version is available now. It includes the Advanced
  SQL Text Editor, SQL Expression Editor, and the SQL Filter Builder.
  The Full-featured demo project now exists in two variants: one for the
  Standard, other for the Professional version. The Trial version includes
  both variants. 
+ The new demo projects have been made: Create Query demo and Edit Metadata
  Container demo.
- The bug with applying result column names for queries with asterisk items
  when fields aren't loaded yet has been fixed.
- Filtration by aggregated columns has been fixed.

June 24, 2017

Active Query Builder VCL Edition v.1.27.2

+ The Custom Expression Editor ellipsis button doesn't hide the combo box
  button in the inline editor of Expression column in the Query Columns
  Grid, but displayed next to it.
- The bug with incorrect loading of conditions joined with the topmost OR
  operator has been fixed.
- Access violation on pressing the TAB key in an empty Query Columns Grid
  control with an inactive editor has been fixed.
+ PostgreSQL, MySQL, SQLite, Netezza: Support for expressions in
  LIMIT/OFFSET clauses has been added.
- TacSubQuery.AddNewCte: Field list is now set up correctly for the newly
  created CTE.

June 10, 2017

Active Query Builder VCL Edition v.

+ Sybase ASA: Compatibility with older server versions has been improved.
+ NativeDB Metadata Provider is capable of loading objects and foreign keys

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: