Downloads

Active Query Builder History History

July 11, 2019

Active Query Builder History v.3.5.22.1136

= Query Transformer: SQL-text based transformations are substituted for
  operations with the AST query tree.

July 09, 2019

Active Query Builder History v.1.29.8

+ SQL Text Editor: The new TextEditorOptions.ReadOnly property has been added.
= SQL Text Editor: The suggestion window behavior has been improved.
= SQL Text Editor: MySQL analytic functions are added to the suggestion list.
= SQL Text Editor: The events for drag'n'drop have been added; support for 
  OLE text drag'n'drop has been made.
= SQL Text Editor: Mouse is captured on selection now.
+ SQL Text Editor: New events are added to customize lists of keywords and
  builtin functions: OnCustomizeKeywords and OnCustomizeFunctions.
- SQL Text Editor: Typing of colon-prefixed parameters has been fixed.
- SQL Text Editor: Slowness in displaying the suggestion list in the case
  of a large database schema has been eliminated.
= TreeOptions: CTEsNodeText and SubQueriesNodeText props are writable now.
- DevExpress: UnionNavBar auto sizing has been fixed.
- Dot-prefixing objects with an empty schema for servers without database
  namespace support has been fixed.
- QueryTransformer: The assignment of random column aliases for transformed
  queries in the Trial version has been fixed.

July 09, 2019

Active Query Builder History 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 History 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.
+ New methods TacQueryBuilder.GetSqlAst/SetSqlAst are added to get/set the
  parsed AST query tree.
= Query Transformer: SQL-text based transformations are made with the query 
  AST tree now.
= AST tree operations have been speeded up.
= Log: the version number is now displayed in the "log opened" message.
= Universal Syntax Provider: add syntax properties autodetection is logged now.
- DevExpress: The width of buttons in the UnionNavBar is fixed.

July 06, 2019

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

July 01, 2019

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

June 26, 2019

Active Query Builder History v.3.4.7

+ The new AQB.Web.UseRelativePaths property allows to treat paths to
  handlers as relative which allows not to hardcode virtual directory.
  Default: False.
= The QueryBuilder.DataSourceOptions.HideAsteriskItem property now affects 
  the dropdown list in the Expression column of the Query Columns List.
= The AQB.Web.QueryBuilder.onQueryBuilderReady event is now fired when 
  the UI is really operable by the user.
- The bug with setting an empty string to the setSql() method when there's
  no SQL Editor on the page has been fixed.

June 26, 2019

Active Query Builder History v.3.5.21.1134

= Metadata Editor: Minor user interface improvements have been made.
- QueryTransformer: The bug with the double expansion of virtual objects 
  has been fixed.
= SQL Text Editor: Support for IME has been improved.
- SQL Text Editor: The bug with scrolling at the error position has been
  fixed.
- The bug with not updating the UI after changing the UseAltNames property
  has been fixed.
- SQL Anywhere: The load of remarks for tables has been fixed, the usage 
  of restricted system views has been avoided, temporary tables are loaded 
  correctly now.

June 26, 2019

Active Query Builder History v.3.5.21.1134

= Metadata Editor: Minor user interface improvements have been made.
- QueryTransformer: The bug with the double expansion of virtual objects 
  has been fixed.
= SQL Text Editor: Support for IME has been improved.
- SQL Text Editor: The bug with scrolling at the error position has been
  fixed.
- The bug with not updating the UI after changing the UseAltNames property
  has been fixed.
- SQL Anywhere: The load of remarks for tables has been fixed, the usage 
  of restricted system views has been avoided, temporary tables are loaded 
  correctly now.