Downloads  »  Active Query Builder ActiveX Edition History

December 07, 2017

Active Query Builder ActiveX Edition v.1.28.2

Below is the list of fixes and improvements in Active Query Builder ActiveX Edition v.1.28.2.

+ The new property ILinkOptions.DefaultLinkType has been added. It 
  determines the type of JOIN created on linking tables by drag'n'drop. 
  Possible values: dltLeft=0, dltRight=1, dltInner=2, dltFull=3.
+ The new properties to format WINDOW clause have been added to 
  ISQLBuilderSelectFormat class: WindowNewLineAfterItem (bool),
  WindowNewLineBeforeComma (bool).
+ The new properties to format CASE and IF expressions have been added 
  to ISQLBuilderSelectFormat class: 
  ConditionalOperatorsNewLineBeforeWhen (bool);
  ConditionalOperatorsNewLineAfterWhen (bool);
  ConditionalOperatorsNewLineBeforeThen (bool); 
  ConditionalOperatorsNewLineAfterThen (bool);
  ConditionalOperatorsIndentExpressions (int): indents expressions in WHEN,
  THEN and ELSE parts of CASE operator;
  ConditionalOperatorsIndentBranch (int): indents each WHEN branch of 
  a CASE expression.
+ 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.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder ActiveX Edition at the download page.

» Full Active Query Builder ActiveX Edition history