Downloads

Active Query Builder WinForms Edition History

February 08, 2010

Active Query Builder WinForms Edition 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 WinForms Edition v.1.11.8.211

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

January 27, 2010

Active Query Builder WinForms Edition 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 WinForms Edition v.1.11.8.209

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

December 30, 2009

Active Query Builder WinForms Edition v.1.11.8.208

+ The new properties are added to the QueryBase 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').
- The AfterPropertiesDialog event was firing even if the dialog has been
  canceled. Fixed now.

November 23, 2009

Active Query Builder WinForms Edition v.1.11.6.206

= DevExpress dependencies are updated to v9.2.9.0.
+ MS SQL: support for old-style TransactSQL outer joins: "*=" and "*=" operators.
  (only if ServerVersion < MSSQL2005)
+ Sybase: support for old-style TransactSQL outer joins: "*=" and "*=" operators.
+ MS SQL: Constants for SQL Server 2008 are added.

November 16, 2009

Active Query Builder WinForms Edition v.1.11.5.205

+ WPF Demo project is added. Active Query Builder is used there in a WPF window
  through the WindowsFormsHost.
- An exception when using Active Query Builder through the WindowsFormsHost is
  fixed.
= Query builder now automatically generates aliases for virtual calculated
  fields if they have no alias defined.
- Firebird: Support of predefined context variables (CURRENT_DATE,
  CURRENT_TIME, CURRENT_TIMESTAMP) is added.

November 11, 2009

Active Query Builder WinForms Edition v.1.11.4.204

- Hotfix for LayoutSQL is made.
- DiagramObjectDeleting event was not fired when closing a diagram object through
  its context menu. Fixed now.

November 10, 2009

Active Query Builder WinForms Edition v.1.11.4.203

- LayoutSQL now saves SQL without virtual objects expansion.
- Virtual objects can have empty aliases. If alias is empty, AQB creates one from
  the virtual object name.
- Metadata relations loading from Sybase ASE is fixed.

November 05, 2009

Active Query Builder WinForms Edition v.1.11.3.201

+ New FieldListDescriptionColumnOptions.UseLongDescription property is added to
  control which description will be shown in the Description column of field 
  lists: if false (default), the MetadataField.ShortDescription is displayed;
  if true, the MetadataField.LongDescription is displayed.
+ New property LoadJoinsFromWhereClause is added. Using this property you can
  instruct the Query Builder to not treat WHERE conditions like "tbl1.FieldName
  = tbl2.FieldName" as joins. They will be loaded in the Columns pane instead.
+ Method GetSchemaNames() retrieving list of database schemas is added to
  syntax providers.
- DB2: Metadata filtering is fixed.
- Memory leak is fixed.

Product Summary

 Active Query Builder WinForms .NET Edition:


 Active Query Builder WPF .NET Edition:


 Active Query Builder ASP.NET Edition:


 Active Query Builder Java Edition:


 Active Query Builder ActiveX Edition:


 Active Query Builder VCL Edition:

Tweets

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!


Social networks