Downloads

Active Query Builder ActiveX Edition History

July 13, 2018

Active Query Builder ActiveX Edition v.1.28.8

= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
= Pervasive: List of keywords and functions has been filled.
= Pervasive: Support of IF function, LIMIT/OFFSET clause has been made.
- Pervasive: Parsing of date/time builtin functions has been fixed.
- Teradata: The bug with the autodetection of new versions has been fixed.
- SQLite: Parsing of queries with RIGHT and FULL joins throws the parsing
  exception now.
- IBM DB2: NULL is parsed as a constant, not as an identifier.
= The LinkOptions.CreateLinksByIdenticalFieldNames behaviour has been changed.
  Links are created only if one of the fields is a part of the primary key.
= Loading of Primary Key fields has been improved.
= Complex SQL expressions aren't loaded as joins anymore.
- Changing of the link type if RIGHT JOIN is not supported is not allowed now.
- The bug with the height calculation of the UNION navigation bar when the
  query has unions in brackets has been fixed.
- Memory leaks have been eliminated.

March 15, 2018

Active Query Builder ActiveX Edition v.1.28.7

= SQLite: The list of reserved words has been filled.

February 28, 2018

Active Query Builder ActiveX Edition v.1.28.6

= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.

February 22, 2018

Active Query Builder ActiveX Edition v.1.28.5

+ Initial support of Pervasive SQL syntax has been added.
- Links cardinality calculation has been fixed.
- MS SQL Server: Multi-column foreign keys loading for SQL Server 2005 and 
  higher has been fixed.
- MySQL: Support of STDDEV function has been fixed.

January 27, 2018

Active Query Builder ActiveX Edition v.1.28.4

= Index numbers in ORDER BY are converted to corresponding expressions now.
= PostgreSQL parser has been optimized.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  an arbitrary order has been fixed.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.
= ODBC: Fetching of databases and schemas is supported now.

December 19, 2017

Active Query Builder ActiveX Edition 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 07, 2017

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.

November 17, 2017

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

October 05, 2017

Active Query Builder ActiveX Edition v.1.28.0

+ Descriptions for database objects and fields are shown in hints in the
  Metadata Tree.
+ Minor SQL formatting improvements and bug fixes have been made.
= 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.
- Several fixes for high resolutions have been made.

September 06, 2017

Active Query Builder ActiveX Edition v.1.27.12

+ DB2: Database objects description fetching for iSeries/AS400 has been
  made.