Downloads

Active Query Builder History History

March 10, 2011

Active Query Builder History v.0.4.9

- The bug with dragging objects from the Database Schema Tree is fixed.

March 09, 2011

Active Query Builder History v.1.3.4.1067

- Fixed diagram pane background painting in Nimbus look'n'feel.
= Query Structure Tree now shows dervied table alias instead of sub-query text.

March 05, 2011

Active Query Builder History v.0.4.8

+ The new Canvas.FieldListOptions property is added to tune the appearance of
  the datasource field lists.
+ The Canvas.AllowLinkManipulations property is changed from boolean to enum 
  with the following possible values: Allow, Deny, AllowJoinTypeChanging. 
  Setting this property to AllowJoinTypeChanging denies all operations 
  with the links except changing the join type.
= Activation Wizard to change the registration key is added to the paid version.
- Fixed bug with clearing the Aggregate column value on changing other cells of 
  the same grid line.

March 02, 2011

Active Query Builder History v.1.3.3.1066

- Hot fix for condition parsing.
- Query update after CTE changes is fixed.

March 02, 2011

Active Query Builder History v.1.14.6.278

+ New events ControlCreated and ControlDestroying are added. You can use them
  for additional customization of the query builder UI controls. E.g., handle
  some control event on ControlCreated and unhandle it on ControlDestroying.
= Expression parsing is improved.
- DB2: Missing Trim(), Position() and Extract() functions are added.
- Fixed diagram objects painting problems when FocusedDiagramObjectColor property
  is specified.

March 02, 2011

Active Query Builder History v.1.16.8

- The bug with entering criteria prefixed with comparison operators is fixed.
  (introduced in 1.16.6)
= Prevented EOL and EOF characters to be included in .hpp files.
= DB2: Additional aggregate functions are added: VAR_POP, VAR_SAMP
= Fixed bug with incorrect removal of selected query fields not related to the
  sub-query on removing same named fields from the sub-query.

March 02, 2011

Active Query Builder History v.1.16.8

- The bug with entering criteria prefixed with comparison operators is fixed.
  (introduced in 1.16.6)
= DB2: Additional aggregate functions are added: VAR_POP, VAR_SAMP
= Fixed bug with incorrect removal of selected query fields not related to the
  sub-query on removing same named fields from the sub-query.

February 24, 2011

Active Query Builder History v.1.3.3.1065

= Expression parsing is improved.
- MySQL: Missing bit operators are added.
- DB2: Missing Trim(), Position() and Extract() functions are added.
- DB2: Fixed some JOIN ambiguities.

February 24, 2011

Active Query Builder History v.1.16.6

- The position parameter in the OnCustomExpressionBuilder event now measured
  from the top-left corner of the component (was of the columns grid control).
- Add Object Form: The ListView display mode is now applied correctly.
+ Add Object Form: Descriptions for metadata objects are displayed now in the
  Report ListView mode.
= MySQL: The || and && operators are treated now correctly according to the
  server configuration (as synonyms for logical OR and AND in default mode).
+ IBM DB2: Statistics aggregate functions are added.
+ IBM DB2: Extended syntax for TRIM, POSITION and EXTRACT functions, string
  types with CCSIDs are supported now.
= The "{expression}" entered to the Condition cell is converted to 
  "= {expression}" now.
- The ColumnPaneVisible property is fixed in Design Time.
+ MySQL: &,|,^,<<,>> operators are supported now.

February 24, 2011

Active Query Builder History v.1.16.6

+ The new properties are added to get access to the active sub-query text:
  ActiveSubQuerySQL and ActiveUnionSubQuerySQL.
- The position parameter in the OnCustomExpressionBuilder event now measured
  from the top-left corner of the component (was of the columns grid control).
- Add Object Form: The ListView display mode is now applied correctly.
+ Add Object Form: Descriptions for metadata objects are displayed now in the
  Report ListView mode.
= MySQL: The || and && operators are treated now correctly according to the
  server configuration (as synonyms for logical OR and AND in default mode).
+ IBM DB2: Statistics aggregate functions are added.
+ IBM DB2: Extended syntax for TRIM, POSITION and EXTRACT functions, string
  types with CCSIDs are supported now.
= The "{expression}" entered to the Condition cell is converted to 
  "= {expression}" now.
+ MySQL: &,|,^,<<,>> operators are supported now.
- CAB signing is fixed.