Downloads

Active Query Builder VCL Edition History

November 22, 2024

Active Query Builder VCL Edition v.1.36.2

+ The new SetAliasesDemo is added.
- DevExpress: The bug with opening the Link properties form is fixed.
- Snowflake DB: The parser ambiguity that caused freezing is eliminated.
- Link Properties form: The natural join editor is hidden if the syntax does 
  not support them.

November 07, 2024

Active Query Builder VCL Edition v.1.36.1

+ MS SQL Server: Support for pasrsing PIVOT and UNPIVOT is added.
- MS SQL Server: Support of aliases after join object hint (NOLOCK) is added.
- IBM DB2: The bug with parsing of VALUES clause is fixed.
- TacCriteriaBuilder: The exception on inserting multiple values where some of
  them are empty is eliminated.

August 30, 2024

Active Query Builder VCL Edition v.1.36.0

+ Oracle, PostgreSQL, MySQL, Snowflake: Support for NATURAL and LATERAL joins 
  is added.
+ MS SQL Server: Support for CROSS/OUTER APPLY is added.
= PostgreSQL: Support for ONLY and [NOT] MATERIALIZED CTE hints is added.

July 11, 2024

Active Query Builder VCL Edition v.1.35.6

= Support for numeric order in queries with an asterisk item is improved.
- SQL Text Editor: List of keywords for PostgreSQL is fixed.

July 05, 2024

Active Query Builder VCL Edition v.1.35.5

+ Full support of numeric column references in the ORDER BY clause is made.
+ Column alias is generated now on adding a column to the ORDER BY by UI.
- PostgreSQL: Keywords list is fixed.
= Criteria Builder: Value conversion on changing the field reference is fixed.
- Criteria Builder: Controls hiding is fixed.

April 26, 2024

Active Query Builder VCL Edition v.1.35.4

= ANSI SQL/92, SQL/2003: Minor compatibility fixes are made.
= Handling of the ORDER BY by column index for unnamed columns is fixed.
= TacBaseMetadataProvider, TacTextDocument: The new OnExecuteThread event is
  added.
- Pervasive: The bug with fields ordering is fixed.
- Criteria Builder: The crash on items destroying is eliminated.

February 28, 2024

Active Query Builder VCL Edition v.1.35.3

- Delphi 2007: Datasource fields list drawing issues are fixed.
- Criteria Builder: The crash on initializing the popup list in some cases is
  fixed.

February 22, 2024

Active Query Builder VCL Edition v.1.35.2

= Pervasive: The load of metadata is improved.
= Installer: Sources and packages are extracted into the public documents folder.
- RAD Studio 12: Datasource painting is fixed.
- RAD Studio 12: Datasource fields filter paiting with Delphi skins is fixed.
- Datasources layout for apps with Delphi skins is fixed.

January 24, 2024

Active Query Builder VCL Edition v.1.35.1

= Oracle: Parsing expressions with parentheses is speeded up.
= MySQL: Parsing of queries with "=false" and "=true" is speeded up.
= MySQL: New aggregate functions are added.
= Snowflake: The bug with some aggregate function names is fixed.
= Snowflake: Support for POSITION and FLATTEN functions is made.
= MS SQL Server: Support for WITHIN expression is made.
= SQL text editor: New SQL Server functions are added to the suggestions list.
- SQL text editor: Suggestions list tooltips are back.
- RAD Studio 12: The bug with clicking on checkboxes in the datasource field
  list when VCL themes are turned on is fixed.
- Old Delphi version incompatibilities are fixed.

November 23, 2023

Active Query Builder VCL Edition v.1.35.0

+ Support for RAD Studio 12 is added.
+ Criteria Builder: The ability to paste a list of values from clipboard to the
  "in list" editor is made.
+ Firebird: Server version autodetection is added.
+ Oracle: Support for percentile_cont, percentile_disc functions is added.
+ Denodo: Support for analytical functions is added.
- DevExpress: Exception on destroying a datasource is elimitated.
- NexusDB: The bug with identifiers comparison is fixed.