Downloads

Active Query Builder History History

July 01, 2020

Active Query Builder History v.2.10.20.831

+ Support for QuickBooks SQL dialect has been added.
+ Support for SAP Hana SQL dialect has been added.
+ PostgreSQL: Support for the DISTINCT ON clause has been made.
= PostgreSQL: Backslash quotation for generic string literals has been dropped.

June 26, 2020

Active Query Builder History v.3.6.6.1164

= QuickBooks: Support for square-brackets quoted identifiers has been added.

June 26, 2020

Active Query Builder History v.3.6.6.406

+ Client-side performance improvements are made.
+ The new server-side QueryBuilder.SQLUpdated event has been added.
- The reinitUrl parameter is added to the QueryBuilder constructor in all
  demos of the JavaScript demo project.
- The bug with getting an old SQL query text from the QueryBuilder.SQL
  property in the SqlUpdated client event handler has been fixed.
- Client-server synchronization bugs are fixed.
- The bug with sorting fields from the datasource context menu is fixed
- Folder nodes are shown correctly in the database schema view tree.

June 26, 2020

Active Query Builder History v.3.6.6.1164

+ Users now can create links from UI separately indicating fields to
  start and finish a new link via the datasource field context menu.
+ Three new events are added to the CriteriaBuilder control:
  NeedEditorForValue, NeedCustomLookupButton, NeedCustomLookupControl.
  They allow for using custom editors for values of specific fields or
  data types.
+ The new demo project CriteriaBuilderCustomize is added to illustrate 
  the way how one can use custom editors, buttons and controls in the 
  CriteriaBuilder control.
+ Source code of the Metadata Container Editor is included in a set of
  demo projects for Trial and Professional versions.
= Criteria Builder: minor fixes and improvements are made.
= QuickBooks: Support for square-brackets quoted identifiers has been added.
- The bug with checking/unchecking an asterisk item in datasources is fixed.

June 26, 2020

Active Query Builder History v.3.6.6.1164

+ Users now can create links from UI separately indicating fields to
  start and finish a new link via the datasource field context menu.
+ Three new events are added to the CriteriaBuilder control:
  NeedEditorForValue, NeedCustomLookupButton, NeedCustomLookupControl.
  They allow for using custom editors for values of specific fields or
  data types.
+ The new demo project CriteriaBuilderCustomize is added to illustrate 
  the way how one can use custom editors, buttons and controls in the 
  CriteriaBuilder control.
+ Source code of the Metadata Container Editor is included in a set of
  demo projects for Trial and Professional versions.
= Criteria Builder: minor fixes and improvements are made.
= QuickBooks: Support for square-brackets quoted identifiers has been added.
- The bug with checking/unchecking an asterisk item in datasources is fixed.

June 17, 2020

Active Query Builder History v.1.30.5

+ Expression Editor: Hints in the list of functions are displayed much longer.
- The exception in RAD Studio 10.4 on form loading is eliminated.
- Installer: SQL Direct DAC detection has been fixed.
- Installer: PackagesDir calculation for C++Builder 6 has been fixed.

June 17, 2020

Active Query Builder History v.1.30.5

= Minor improvements have been made.

June 11, 2020

Active Query Builder History v.1.30.4

+ Support for RAD Studio 10.4 Sydney has been added.
+ Users now can create links from UI separately indicating the beginning and 
  end field via the datasource field context menu.
= PostgreSQL: Backslash quotation for generic string literals has been removed.
- TacCriteriaBuilder: The bug with defining general condition has been fixed.

June 11, 2020

Active Query Builder History v.1.30.4

+ Users now can create links from UI separately indicating the beginning and 
  end field via the datasource field context menu.
+ The new property ActiveQueryBuilderX.SwapSidePanels has been added to swap
  the Database Schema Tree and the Query Structure Tree.
= PostgreSQL: Backslash quotation for generic string literals has been removed.

June 10, 2020

Active Query Builder History v.3.6.5.1163

+ Metadata loading errors are displayed now via the notification bar.
+ The new property QueryBuilder.BehaviorOptions.AllowMessageTypes is added 
  to determine the types of messages to be shown in the notification bar.
+ The new property QueryBuilder.DesignPaneOptions.DesignPaneOverviewMaxHeight
  is added to determine the maximum ratio (range from 0 to 1) of the overview
  pane height and overall Design Pane height. 
  The actual width and height of the overview pane is now calculated 
  according to new and DesignPaneOverviewWidth properties.
= Significant performance improvements are made.
= QuickBooks (QODBC): Support for the TOP clause is added, support for derived 
  tables is turned off.
= PostgreSQL: Backslash quotation for generic string literals has been removed.
= Metadata serialization to XML: The "Loaded" flag for all types of objects
  is now set on for a namespace if child database objects of any type exist.