Downloads

Active Query Builder ActiveX Edition History

July 09, 2019

Active Query Builder ActiveX Edition v.1.29.8

- Dot-prefixing objects with an empty schema for servers without database
  namespace support has been fixed.

July 06, 2019

Active Query Builder ActiveX Edition v.1.29.7

+ Query Structure Tree: sub-queries from WHERE and SQL expressions from other
  parts of the query are shown in the tree now.
= AST tree operations have been speeded up.

July 01, 2019

Active Query Builder ActiveX Edition v.1.29.6

= New server versions are listed now for MySQL, MS SQL, Oracle syntaxes.
= Link Properties Form: The single-line expression editor has been replaced
  with a memo field.
- Visibility of the UnionNavBar is restored correctly now after updating 
  the UnionTabSheet params.
- SAP SQL Anywhere: Loading of objects for a non-privileged user has been
  fixed; modern views are used now for v.17 and higher.
- Universal Syntax Provider: The detection of database and schema namespaces
  usage is performed now. It now works fine with the Absolute DB.
- SQLite: Union operators list has been fixed.

May 08, 2019

Active Query Builder ActiveX Edition v.1.29.4

+ Dutch localization has been added.
+ The Query Structure Tree is improved. It is more sensibly organized and 
  allows performing various actions with nodes using context menus. 
= MS SQL Server: Objects from linked servers without database or schema
  support are retrieved fine now.
= MySQL: The default server version is set to 8.0.
= Pervasive: Parsing of some built-in functions has been fixed.
= Minor SQL formatting fixes and improvements have been made.
= PostgreSQL: "table.*" is accepted now as an ordinary row expression term.
= NexusDB: The list of reserved words has been updated.
= SAP Hana: Support for missing functions has been added: LEFT, RIGHT and
  (REPLACE/SUBSTR/OCCURRENCES)_REGEXPR.
- Scaling issues have been fixed.
- The bug with not switching to the new subquery on creating a Derived Table
  has been fixed.

January 21, 2019

Active Query Builder ActiveX Edition v.1.29.3

- Turning off grouping in the query via the global Grouping checkbox in the
  header of Query Columns List may lead to inconsistent queries. Fixed now.
- PostgreSQL: Parsing ambiguities for INTERVAL and AT TIME ZONE clauses have
  been fixed.

December 11, 2018

Active Query Builder ActiveX Edition v.1.29.0

+ Initial support of SAP Hana SQL syntax has been added.
+ Initial support of Pervasive SQL syntax has been added.
+ MySQL: Support for Common Table Expressions for MySql v8+ has been added.
+ 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.
= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.
+ The new  properties have been added to the ActiveQueryBuilderX object to
  hide the controls for managing subqueries: SubQueryTabsVisible,
  UnionNavBarVisible.
= The behavior of LinkOptions.CreateLinksByIdenticalFieldNames property
  has been changed. Links are created only if one of the fields is a part 
  of the primary key.

November 19, 2018

Active Query Builder ActiveX Edition v.1.28.11

+ MySQL: Support for Common Table Expressions for MySql v8+ has been added.
= Oracle: Support for ranking functions has been updated.
- PostgreSQL: Parsing of the "AT TIME ZONE" clause and "EXTRACT(epoch FROM 
  ...)" function has been fixed.
- MS Access: Parsing of the TRUE and FALSE constants has been fixed.
- The Union Navigation Bar scaling issues have been eliminated. 

September 23, 2018

Active Query Builder ActiveX Edition v.1.28.10

- Minor bugs have been fixed.

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.

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:

Tweets

Testimonials

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