Downloads

Active Query Builder History History

December 29, 2017

Active Query Builder History v.3.3.26.1074

	
+ On-demand metadata loading improvements have been made to speed up field
  list retrieval when adding a new object to the query.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  an arbitrary order has been fixed.
- SQL Text Editor: The bug with Undo operation has been fixed.

December 19, 2017

Active Query Builder History v.1.28.3

+ Help strings for new properties have been added.
= MS SQL Server: The DB_NAME function is used now to the get current db name
  on MS SQL Server 2008 and higher.

December 19, 2017

Active Query Builder History v.1.28.3

= Compatibility with the latest DevExpress 17.2 version.
= MS SQL Server: The DB_NAME function is used now to get the current db name
  on MS SQL Server 2008 and higher.

December 13, 2017

Active Query Builder History v.3.3.25.1073

+ Sybase: Support for window functions has been added.
= User Queries: Exception is thrown now if query expression has output
  column names conflicts.
= Teradata: Minor metadata loading improvements have been made.
- SQL Text Editor: The bug with caret position after removing a character
  and scrolling has been fixed.
- SQL Text Editor: The bug with the content of suggestion window not taking
  the last input character into account has been fixed.
- Loading of stored procedure parameters from metadata XML files has been
  fixed.
= Fields in datasources can be checked with the space key now.

December 13, 2017

Active Query Builder History v.3.3.25.1073

+ Sybase: Support for window functions has been added.
= User Queries: Exception is thrown now if query expression has output 
  column names conflicts.
= Teradata: Minor metadata loading improvements have been made.
- Loading of stored procedure parameters from metadata XML files has been
  fixed.

December 13, 2017

Active Query Builder History v.3.3.25.1073

+ Sybase: Support for window functions has been added.
= User Queries: Exception is thrown now if query expression has output
  column names conflicts.
= Teradata: Minor metadata loading improvements have been made.
- SQL Text Editor: The bug with caret position after removing a character
  and scrolling has been fixed.
- SQL Text Editor: The bug with the content of suggestion window not 
  taking the last input character into account has been fixed.
- Loading of stored procedure parameters from metadata XML files has been
  fixed.
- Incorrect re-ordering of rows by drag'n'drop in the Query Columns Grid 
  has been fixed.

December 07, 2017

Active Query Builder History 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.

December 07, 2017

Active Query Builder History 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 30, 2017

Active Query Builder History v.3.3.24.1072

- Query Transformer: Applying both pagination and sort order has been fixed.

November 30, 2017

Active Query Builder History v.3.3.24.1072

- Query Transformer: Applying both pagination and sort order has been fixed.
= SQL Text Editor: "Dual" has been added to the list of suggestions for
  Oracle.
- The bug with black background in cell editors of the Query Column List on
  certain systems has been fixed.