Active Query Builder VCL Edition History

December 07, 2017

Active Query Builder VCL Edition v.1.28.2

+ Sybase: Support of window functions has been added.
= Teradata: Fetching fields from server system catalog has been speeded up.
= Query Columns Grid: parsing of user input of criteria has been improved.
- SQL Anywhere: Detection of new versions has been fixed.
- Oracle: Unsupported comparison operators !> and !< have been removed.
- SQL parsing has been speeded up.

November 17, 2017

Active Query Builder VCL Edition v.1.28.1

+ Now it's possible to add and remove rows in the Query Columns List using
  the Alt+Insert and Alt+Delete keyboard shortcuts, move them up and down
  using the Alt+[Arrow Up/Down] keys.
= Sybase: Case-sensitive identifiers are used now for Sybase ASE.
= Oracle: complex SQL queries parsing has been speeded up.
= IBM DB2: Both LabelText and Remarks are used as LongDescription for fields  
  for the QSYS2 schema.
- The bug with keyboard navigation in the Query Columns List has been fixed.
- Minor SQL formatting fixes have been made.
- Minor HighDPI scaling issues have been fixed.
- Query Columns List cell painting bug has been fixed.
- The Links menu item captions have been restyled, the bug with a foreign
  key referenced to itself has been fixed.
- MySQL: The bug with parsing of DateDiff and TimeDiff functions has been

October 05, 2017

Active Query Builder VCL Edition v.1.28.0

+ Constants for new server versions have been added to appropriate syntax
+ Descriptions for database objects and fields are shown in hints in the
  Metadata Tree.
+ On adding a stored procedure (table-valued function), a prompt for its
  parameters does not appear anymore. Instead, you can open the datasource
  properties dialog (by selecting the Properties context menu item or by
  double-clicking on a datasource) and edit procedure parameters there.
  Those who want to display a dialog on adding a stored procedure can 
  handle the OnGetProcedureParameters to prompt the user for parameters.
+ The new LinkOptions.DefaultLinkType property has been added. It lets 
  prescribe to create left, right or full outer join instead of inner join
  on linking tables by drag'n'drop.
+ The new TSQLBuilder.SubqueryTextFromNewLine propery has been made to 
  break line between the sub-query text and the parentheses enclosing it.
+ The new group of properties has been made to customize formatting for 
  IF and CASE clauses: TSQLBuilderSelectFormat.ConditionalOperatorsFormat.
+ Minor SQL formatting improvements and bug fixes have been made.

+ SQL Text Editor (Professional): The new TextEditorOptions.UseTabCharacter
  property has been added.
- SQL Text Editor (Professional): Some bugs are fixed, minor improvements
  have been made.

+ The new OnMetadataTreeNodeGetCaptionText and OnMetadataTreeNodeGetHintText
  events have been added to customize the text of captions and hints for
  nodes of the Metadata Tree.

= MySQL: Default server version is bumped to v.5.7.
= MySQL: The list of valid identifiers has been actualized.
+ MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been

= PostgreSQL: The ComparisonOperators syntax provider property now stores
  only user-defined operators.
+ PostgreSQL: Support for "$n"-style positional params has been added.

+ The new SelectListOptions.GridLinesColor property has been added. 
  Being set to clNone it doesn't affect the painting.
- DevExpress: Some fixes for dark skins have been made.
- Several fixes for high resolutions have been made.

September 06, 2017

Active Query Builder VCL Edition v.1.27.12

+ DB2: Database objects description fetching for iSeries/AS400 has been
= NexusDB 4: Package references are updated to the latest version 4.12.
- MS SQL Server: Query Properties forms compilation for DevExpress controls
  has been fixed.

September 05, 2017

Active Query Builder VCL Edition v.1.27.11

- Query Transformer: The bug with creation of filter expression for a column 
  with quoted aliases has been fixed.
- The bug with removing a derived table via the context menu command has
  been fixed.
- PostgreSQL: Parsing of string literals with ''-quoted apostrophes has been
+ MS SQL Server: Support of SELECT into local var (SELECT @localVar = 10)
  has been added.
- Several DevExpress controls UI bugs have been fixed. 
- Compilation of Metadata Provider for DOA has been fixed.
+ Criteria Builder: The new ReadOnly and Color properties have been added. 
+ Criteria Builder: Minor bug fixes and improvements have been made.
- The "Field not found" bug in Criteria Builder has been fixed.
- Text Editor: Selection movement on indent/unindent commands has been
- Text Editor: The bug in Replace command in selection has been fixed.
= Localization files have been updated, missing strings have been added.

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.

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: