Downloads  »  Active Query Builder VCL Edition History

October 05, 2017

Active Query Builder VCL Edition v.1.28.0

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

+ Constants for new server versions have been added to appropriate syntax
  providers.
+ 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
  made.

= 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.

[           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