Downloads

Active Query Builder ActiveX Edition History

July 15, 2016

Active Query Builder ActiveX Edition v.1.26.23

- If word wrapping is enabled by the RightMargin property, wrapped text 
  is properly indented now.
- Informix: Support for date builtin functions like YEAR is fixed.
- MS SQL Server: Support for new DatePart items (ISO_WEEK, TZOffset, ...) 
  is made.
- The PropertiesXml property of QueryBuilder and PlainTextSQLBuilder 
  now accepts empty string.
- Focus is set to the Select List Control now when property 
  CustomExpressionBuilder.NewExpression is assigned.
= New constants are added to determine possible values of the
  UseCustomExpressionBuilder, DisableDirectEditingIn properties:
  acColumnNone = 0 - don't apply to any column,
  acColumnAll = 3 - apply to both Expression and Criteria columns.
- Split Panel: Bottom and top heights ratio is updated when absolute value 
  of the bottom panel height is set.

July 11, 2016

Active Query Builder ActiveX Edition v.1.26.22

+ New properties are added to the SelectListOptions group:
  UseCustomExpressionBuilder, DisableDirectEditingIn. Possible values:
  acColumnExpressions = 1 - apply to Expression column, 
  acColumnConditions = 2, - apply to Criteria and subsequent columns,
  acColumnExpressions+acColumnConditions = 3 - apply to both.
+ The Design Area and Query Columns Grid are resized proportionally now
  on rezising the control.
= The QueryBuilder.Clear method preserves design pane splitter position.
= Linked Objects menu: a table wouldn't been added to query if such 
  object already presents in this sub query.
- The SQLBuilder.IndentGlobal property is fixed now.
- Fonts are scaled according to the parent font now.
- Unnamed columns from derived tables aren't shown on the Design Pane.
- Column aliases aren't used anymore in the GROUP BY clause if server 
  doesn't support that.

June 16, 2016

Active Query Builder ActiveX Edition v.1.26.21

- Query layout doesn't restored from empty layout data.
- Erroneous token number was reported incorrectly on SQL parsing error.
  Fixed now.

May 31, 2016

Active Query Builder ActiveX Edition v.1.26.20

+ Aliases are assigned now for aggregated columns.
- Add Object Dialog: Previously selected schema is restored correctly.
- Statistics isn't updated now if QueryBuilder in "destroying" state
- MS SQL Server: Parsing speed is improved.
- Loading of a CROSS JOIN in the middle of the FROM clause is fixed.

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