Downloads

Active Query Builder ActiveX Edition History

December 08, 2016

Active Query Builder ActiveX Edition v.1.26.30

+ The new IActiveQueryBuilderX.PartialMetadataLoading property has been
  added. Setting it to True prescribes the component to load metadata only
  for objects that were used in the query on assigning it to the SQL
  property. 
+ Mouse wheel works now in pick up lists of the Query Columns Grid.
+ The MetadataContainer.LoadFromXML method is significantly speeded up.
- Firebird: Support of aliases in the ORDER BY clause only for the version
  2.0 and higher.
- MS SQL Server: List of valid identifiers list has been updated.
- Single-line comments are recognized properly now.

November 23, 2016

Active Query Builder ActiveX Edition v.1.26.29

+ Scrolling by mouse wheel now works in the drop-down pick list of the
  Expression cell editor.
= The FieldListDescriptionColumnOptions.ShowLongDescription property is 
  now set to True by default.
= Minor column type painting improvements in datasource field lists have
  been made.
- Calculation of checked fields in datasource field lists has been fixed.
- The Varchar(Max) and Varbinary(Max) types are displayed correctly now.
- MS Jet: Excel sheet names with the dollar sign are supported now.
- Oracle: Support for the special form of TRIM function has been added. 
- MS SQL Server: ROW and ROWS are added to the list of valid identifiers.
- Other minor bugfixes and improvements have been made.

October 13, 2016

Active Query Builder ActiveX Edition v.1.26.28

+ Query Transformer is now capable to rename output query columns.
+ The new property aqbxQueryTransformer.RenameDuplicatedColumns property 
  prescribes to explicitly specify all the columns in the query SELECT list 
  by expanding the asterisk items, then find and rename unnamend and 
  duplicated column names (default = false).
+ The new aqbxQueryTransformer.AlwaysExpandColumnsInQuery instructs to perform
  asterisk expansion in the query SELECT list even if it's not needed for the
  specified query transformations (default = false).
! The aqbxOutputColumn.Name property is renamed to OriginalName.
+ The new aqbxOutputColumn.PreassignedName allows to specify the needed name
  for a query output column.
+ The new aqbxOutputColumn.ResultName gets the result query columns name which
  turned out as a result of automatic columns renaming routine and manual 
  appliance of the new name specified via the PreassignedName property.
- QueryTransformer: The bug with sorting by a column , which alias is equal 
  to field name is fixed.
- The "Build Expression" popup menu item is now shown only when a handler
  is assigned to the OnCustomExpressionBuilder event.
- MS SQL Server: CHAR(n) parser ambiguity is fixed.
- MS SQL Server: CHAR and NCHAR are moved from the builtin functions to the 
  list of valid identifiers.
+ PostgreSQL: Support for custom aggregate functions is added.
- PostgreSQL: Date/time parts are added to the list of valid identifiers.

September 07, 2016

Active Query Builder ActiveX Edition v.1.26.26

- Query Columns Grid: Changes in inplace editors are committed on focus lost.
- PostgreSQL: Parsing of set operators is fixed.

August 02, 2016

Active Query Builder ActiveX Edition v.1.26.25

- SQLite: Support for CHAR builtin function is added.

July 29, 2016

Active Query Builder ActiveX Edition v.1.26.24

- Parsing of queries with grouping or ordering by integer constants is fixed.
  (treat them as column references)
= Query Columns List: Inplace editor is still visible now when focus is lost.
- PostgreSQL: User-defined prefix operator precedence is fixed.

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.