Downloads

Active Query Builder VCL Edition History

February 08, 2023

Active Query Builder VCL Edition v.1.32.3

- DevExpress: The crash on displaying popup menu is eliminated

February 06, 2023

Active Query Builder VCL Edition v.1.32.2

+ The new component TacCriteriaBuilderFilterList is added. It adds the 
  possibility to save user filters between work sessions. 
- DevExpress: dxBar package is added to the references section of acQueryBuilder
  package.
- MS SQL Server: The ambiguity on parsing a JOIN without join type is fixed.
- The bug with the incorrect fix-up for column names in sub-queries ORDER BY
  clause is fixed.

January 19, 2023

Active Query Builder VCL Edition v.1.32.1

- MySQL: Hanging on parsing queries with GROUP_CONCAT functions is fixed.
- Crash on using the "Wrap Into Derived Table" feature for some queries is fixed.
- Crash on drawing the datasource selection frame in rare circumstances is fixed.

December 30, 2022

Active Query Builder VCL Edition v.1.32.0

+ Now it's possible to select multiple datasources in the Design Pane in 
  different ways:
  - select all datasources in a rectangular area with the mouse, 
  - select individual datasources while holding the Ctrl key,
  - select all the intermediate datasources between the given two ones
    (by joins) holding the Shift key.
+ The new "Wrap into derived table" action is added to the datasource 
  context menu to pack one or several datasources in a new derived table 
  preserving the joins and conditions in the current subquery. 
= Themes/skins compatibility is improved.
- acCriteriaBuilder: Occasional crashing in x64 version is fixed.
- TacDateTimePicker.ConvertFormat: Format definition string for ftDate and
  ftTime is fixed.
= DevExpress: DevExpress menu items are used for context menus.
! DevExpress: Minimal required version is raised up to v.20.

December 02, 2022

Active Query Builder VCL Edition v.1.31.14

+ Criteria Builder: Lots of UI and UX improvements and fixes are made.
+ TacBaseMetadataProvider: The new OnDataSetCreate event is added.
= SQL Server: Alias is made required for table-valued functions to distinct 
  them from tables with hints.
- Oracle: Support for VALIDATE_CONVERSION built-in function is corrected.
- Using correct field name in ORDER BY if query has set operators (UNION, etc.)
- SAP Hana: Support for CHAR built-in function is fixed.
- Delphi 6 and 5 minor string conversion issues are made.

July 15, 2022

Active Query Builder VCL Edition v.1.31.13

+ TacCriteriaBuilder: Users can copy and paste the list of values for 
  the "in list" operator conditions.
- SQL Text Editor: Text editor actions auto-disabling is fixed.
- SQL Text Editor: The selection after Undo/Redo is fixed.
+ TacFindAndReplace: New events OnFindAndReplaceDialogShow, 
OnFindAndReplaceDialogClose are added.
= Oracle: Type precision for NUMBER type is displayed now.
- Pervasive: SQL parser ambiguity in datetime functions is eliminated.

May 19, 2022

Active Query Builder VCL Edition v.1.31.12

= MySQL: Support for JSON extraction operators is added.
= SQL Text Editor: StayOnTop flag is removed from the Search'n'Replace dialog.
- Design Pane: Redrawing of datasource field lists is fixed.
- Design Pane: Minor HiDPI drawing fixes are made.

May 06, 2022

Active Query Builder VCL Edition v.1.31.11

= The load of conditions with double-negated logical fields, such as "not not
  tbl.LogicalField" is fixed.
= Denodo SQL syntax: The list of built-in functions is updated.

April 20, 2022

Active Query Builder VCL Edition v.1.31.10

= Criteria Builder: Minor usablility improvements and bug fixes are made.
= Query Columns List: Logical expressions such as EXISTS subqueries aren't set
  visible automatically, but used for filtration purposes by default.

April 12, 2022

Active Query Builder VCL Edition v.1.31.9

= Criteria Builder: Entering values in the list editor is made easier:
  Enter now moves focus to the next item, Alt+Home/End shortcuts move focus to
  the first/last item in the list.
= Criteria Builder: Automatic transition between date parts in DateTime picker
  when typing is made.
= Criteria Builder: Icons are scaled properly in HiDPI resolutions now.
- Criteria Builder: Entering minutes same as months is fixed in the DateTime
  picker.
= Design Pane: Join type markers in MSSQL-style mode are scaled properly in
  HiDPI resolutions now.
- Query Column List: Row selection and re-ordering by mouse is fixed.
- Query Column List: "=TRUE" is added automatically to the Criteria cell on
  entering logical expressions like "EXISTS" sub-queries.
= MS SQL Server: Support for "FOR JSON" clause is added.
= MS SQL Server: Support of JOIN without type is added. 
- Oracle: Parsing of default value clause for conversion functions is fixed.
- SAP Hana: Parsing of YEAR/HOUR/MINUTE/... builtin functions is fixed.
- PostgreSQL: The DEFAULT token is added to the list of keywords.
- InterBase: The bug with applying limits in the QueryTransformer is fixed.
- SQLite: Extracting DateTime values from the parsed expression is fixed.