Downloads

Active Query Builder History History

March 11, 2010

Active Query Builder History v.1.15.0.0

+ Now it's possible to add Common Table Expressions visually using the context
  menu item of the query building area.
+ Wheel scrolling in field lists is made.
= The ParenthesizeSingleCriterion property is applied now to join conditions.
- Bug fixed: Wrong names fixup for select items like "table.*" if more than one
  "table" objects were used in the query.
- Firebird: Parameter names can use the '#' symbols now.
- The WorkOffline property wasn't taken into account when loading fields for
  stored procedures. Fixed now.
- MS Access: Bug with unsupported FULL OUTER JOIN is fixed.
- PostgreSQL: The list of unifying operators is fixed.
- MS Access: "NULL" is excluded from the list of valid identifiers.
- DAX error is fixed one more time.

March 09, 2010

Active Query Builder History v.1.12.1.215

+ French translation is added.
- Flickering of data source controls during the resizing is reduced.
- Weird exception "Used metadata provider cannot automatically load metadata"
  of OracleMetadataProvider is fixed.
= The Full-featured MDI Demo is improved. New buttons are added to the toolbar
  to fire specific context menu actions of the component (add object, derived
  table, show query properties, add new and copy the current union sub-query).

March 05, 2010

Active Query Builder History v.0.0.3

+ First downloadable package is made.

February 17, 2010

Active Query Builder History v.1.12.0.213

+ MSSQLCEMetadataProvider and MSSQLCESyntaxProvider are implemented to support
  Microsoft SQL Server Compact Edition.
= DevExpress dependencies are updated to v.9.3.3.0.

February 08, 2010

Active Query Builder History v.1.11.9.212

+ Re-arranging of criteria list items by drag and drop is implemented. You can
  drag items using row headers only. To set up the row headers width use the
  CriteriaListOptions.RowHeaderWidth property.

February 03, 2010

Active Query Builder History v.1.11.8.211

- MS Access: Bug with unsupported FULL OUTER JOIN is fixed.

January 27, 2010

Active Query Builder History v.1.11.8.210

= The query builder now loads ActiveDatabaseSoftware.DevExpressControlFactory.dll
  not from the current application directory, but from the directory where the
  application executable is located.

January 15, 2010

Active Query Builder History v.1.11.8.209

- Disposing exception in the SQL2003SyntaxProvider is fixed.
- A workaround for some DevExpress.XtraEditors.PanelControl disposing bugs is
  made.

January 11, 2010

Active Query Builder History v.1.2.4.1024

+ The new properties are added to the QueryBase class to set up the Union
  operator programmatically:
  - get/setUnionOperator(): gets/sets the unifying operator ('Union', 'Except',
    'Intersect' etc.);
  - is/setUnionAllFlag(): gets/sets the 'All' keyword for the operator;
  - get/setUnionOperatorFull(): gets/sets the full operator string (e.g. 'Union
    All').
+ The new get/setDiagramPaneVisible() property is made to show hide the diagram
  pane.
- The AfterPropertiesDialog event was firing even if the dialog has been
  canceled. Fixed now.

January 11, 2010

Active Query Builder History v.1.14.14.0

+ The new property is made to accept tabs in the columns pane.
  TacQueryBuilder.SelectListOptions.AcceptTabs: boolean; default true;
+ The new properties are added to the TacQueryBase class to set up the Union
  operator programmatically:
  - UnionOperator: gets/sets the unifying operator ('Union', 'Except',
    'Intersect' etc.);
  - UnionAllFlag: gets/sets the 'All' keyword for the operator;
  - UnionOperatorFull: gets/sets the full operator string (e.g. 'Union All').
+ Aliases for virtual calculated fields are added automatically now if they
  aren't defined by the user.
+ Firebird: Predefined context variables are supported now: CURRENT_DATE,
  CURRENT_TIME and CURRENT_TIMESTAMP.
+ Firebird: "IS DISTINCT FROM" operator is supported now.
+ MS SQL Server, Sybase: Support of the old-style TransactSQL outer join
  operators ("*=" and "*=") is made. 
- The component doesn't trim right spaces when creating field's aliases from
  alternate names now.
- MySQL: Better support of CONVERT function is made.
- PostgreSQL: Metadata filtration is fixed.
- Popup menu for the grid inplace editor is restored now.
- The LayoutSQL property does not expand virtual fields and objects now.
- Create derived table access violation is fixed now.
- Sybase ASE: Relations metadata loading is fixed now.