Active Query Builder ActiveX Edition History

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

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

September 05, 2017

Active Query Builder ActiveX Edition v.1.27.11

- 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 fixed.
+ MS SQL Server: Support of SELECT into local var (SELECT @localVar = 10)
  has been added.
= Localization files have been updated, missing strings have been added.

August 18, 2017

Active Query Builder ActiveX Edition v.1.27.10

+ The new property ISelectListOptions.DropdownInExpressionColumn has been
  added. Turn it off to hide the drop-down list in the Expression column of
  the Query Columns Grid.

August 15, 2017

Active Query Builder ActiveX Edition v.1.27.9

- Localization fixes in Properties forms have been made.
- Correct column prefix is emitted for procedures and table-valued functions.
- Minor memory leaks have 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:



We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks