Downloads

Active Query Builder ActiveX Edition History

March 21, 2016

Active Query Builder ActiveX Edition v.1.26.19

- Changes made to criteria of invisible cells weren't applied to the query.

March 16, 2016

Active Query Builder ActiveX Edition v.1.26.18

- Loading of subqueries from condition cells for "IN (subquery)"
  expressions is fixed.

March 15, 2016

Active Query Builder ActiveX Edition v.1.26.17

- The ActiveQueryBuilderX.MetadataContainer.DefaultSchemaNames collection
  is fixed.
= Better row height sizing in the Select List Control using custom fonts
  is made. 
- The error with quotation of sub-query text in the cells of Select List
  Control is fixed.

March 02, 2016

Active Query Builder ActiveX Edition v.1.26.16

+ The new property IActiveQueryBuilderX.TableWidthMode is added to determine
  width of new datasources on Design Pane. Possible values:
  twmFixed=0 - fixed, specifed by the DefaultTableWidth property,
  twmAutosizeByContent=1 - calculated to fit the while text content,
  twmAutosizeByFieldName=2 - calculated to fit the longest field name.
- Hanging on exit in case of ODBC connection is fixed now.
- The bug with empty fields list in case of ODBC connection is fixed.
- Query Column List control: The "Sort Type" column autosize is fixed.

February 20, 2016

Active Query Builder ActiveX Edition v.1.26.15

= MS SQL Server: Parsing performance is improved.
- The SelectList.SortOrder setting is fixed.
- Query Columns List: The fix for "Aggregate" and "Grouping" columns
  auto-fit is made. 

February 15, 2016

Active Query Builder ActiveX Edition v.1.26.14

+ The new property is added to the CustomExpressionEditorParams object
  to determine the index of condition/or column: ConditionIndex. 
+ Fitting of the Query Column List's column width on double clicking on
  the column splitter is made.
= The missing property Scale is added to the IMetadataField interface.
= Addition or modification of expressions via the OnCustomExpressionEditor
  event handler now follows the same rules as changing them via the query
  building UI by end-user. (eg. checking of the Visible field for new rows,
  assigning aliases to resolve column name conflicts, etc.)

February 10, 2016

Active Query Builder ActiveX Edition v.1.26.13

= Firebird: Domain name is shown now instead of type name in datasource
  field lists.
- Database Schema Tree wasn't scrolled to the top after reload. Fixed now.
- The SubQuery.Clear clears the WITH clause as well.

February 02, 2016

Active Query Builder ActiveX Edition v.1.26.12

+ API reference in CHM format is added.
+ Help strings are added for all Interfaces, Methods and Properties in the
  type library.
= Metadata Tree size is constrained now.
= Design Pane: Aggregated fields are checked now in Datasource controls.
- The TAB key behaviour in the last column of Select List is fixed.

January 25, 2016

Active Query Builder ActiveX Edition v.1.26.11

= The control doesn't get disconnected on setting the ConnectionTimeout and
  CommandTimeout properties.

January 22, 2016

Active Query Builder ActiveX Edition v.1.26.10

+ Query Column List Control now always displays the "Delete item" button.
+ MS SQL: Support for COLLATE clause for column expressions is made.
- Access Violation in the "Remove CTE" event handler is eliminated.
- Double firing of the OnSQLUpdated event is fixed.
= Non-zero default values are set for the ConnectionTimeout and 
  CommandTimeout properties of a new AQB instance.
= Localizer: CurrentLanguage property accepts -1 as "no language" value.