Active Query Builder WinForms Edition History

March 10, 2009

Active Query Builder WinForms Edition v.

- Oracle: query builder now loads only metadata objects with granted SELECT right.
- Bug with SubString function is fixed.

March 05, 2009

Active Query Builder WinForms Edition v.

+ New events are added to control adding of new expressions from the query
  building area (by clicking a checkbox, double-clicking a field or gragging 
  them to the grid): DatasourceFieldAdding, DatasourceFieldAdded.
+ Demonstration of DatasourceFieldAdding is added in the Events Demo.
= On saving metadata to XML file in Offline mode, the query builder does not
  try to load missing object columns from database now. This allows to cache
  database objects without their fields in XML file.
+ Metadata caching example is added to the Full Featured Demo project.

February 25, 2009

Active Query Builder WinForms Edition v.

+ The new DenyIntoClause property is added to MSAccessSyntaxProvider, 
  MSSQLSyntaxProvider and MySQLSyntaxProvider to allow/deny usage of the INTO
  clause in SQL queries.
+ The LoadMetadataDemo is modified. Demonstration of loading metadata from a 
  stored DataSet is added.
+ Visual Basic version of the FullFeaturedMdiDemo is added.
+ New property StatisticsOutputColumn.MetadataObject is added.
= Now you can invoke the Query Properties dialog with double click on the
  diagram pane (this was possible only through the context menu only).
- Minor memory leaks are fixed.

January 30, 2009

Active Query Builder WinForms Edition v.

+ Now you can drag and drop fields from datasource objects right onto the
  criteria list (grid).
+ Double click on a datasource field adds it to the criteria list now.
- Oracle syntax: Wrong loading of some WHERE constructions is fixed.

January 29, 2009

Active Query Builder WinForms Edition v.

+ The new property FieldListOptions.SortType allows to sort data source fields
  by name or description.
+ The new property FieldListOptions.KeyFieldsFirst allows to keep primary key 
  fields always on the top of the field lists.
- Oracle syntax: missing "MONTH", "DAY", "HOUR" and "MINUTE" keywords are added.
- Rare type cast exception is fixed.
- Bug with duplicating of sub-query tabs is fixed.

January 16, 2009

Active Query Builder WinForms Edition v.

+ New sample project is added. The EventsDemo demonstrates using of few useful
  events to get control over the query building process.
+ The new LinkDragOver event is added.
+ The new FlatBorders property makes most of controls have single (flat) border.
= The LinkCreating event now fired only on the mouse drop.
- MySQL: "REPLACE" function is supported now.
- Bug in metadata filtering is fixed.

January 05, 2009

Active Query Builder WinForms Edition v.

+ New datasource context menu items are added to check/uncheck all fields 
  for a datasource.
+ Downgrade links of loaded query is implemented when Syntax changed to one 
  which doesn't support ANSI joins.
+ New events are added to control displaying of the properties dialogs: 
  QueryBuilder.BeforePropertiesDialog and QueryBuilder.AfterPropertiesDialog.
- Fixed problem with retrieval of the current schema for DB2 for AS/400.

December 30, 2008

Active Query Builder WinForms Edition v.

- Missing "extract" function is implemented in Oracle syntax.
- Missing "model" keyword in Oracle syntax is added.

December 29, 2008

Active Query Builder WinForms Edition v.

+ New properties are added to take control over the links creation process: 
  - LinkManipulations: enum(Allow, Deny, AllowRelationsOnly)
    allows/denies link creation by end-user, or allows creation of links 
    for foreign keys only;
  - CreateLinksFromRelations: Boolean
    allows/denies automatic links creation from foreign keys;
  - LinkCompatibleTypesOnly: Boolean
    allows links creation only for fields with compatible data types only.

+ New events are added to control specific end-user manipulations:  
  - QueryBuilder.BeforeDatasourceFieldDrag:
    set this event to deny dregging of specific fields to create links;
  - QueryBuilder.LinkCreating, QueryBuilder.LinkCreated:
    set these events to allow/deny or perform actions on creating a link;
  - QueryBuilder.LinkDeleting:
    set this event to allow/deny deletion of a link;
  - QueryBuilder.GridCellChanging, QueryBuilder.GridCellChanged:
    set these events to allow/deny or perform actions on changing values 
    at the columns pane grid.

+ New event is added to customize captions of datasources at the query 
  building area: QueryBuilder.CustomizeDatasourceCaption.

- Parameters parsing in MSSQL and Oracle syntaxes is improved.

December 26, 2008

Active Query Builder WinForms Edition v.

- The bug in component disposing is fixed.
- Oracle syntax: "ZONE" is now treated as valid identifier.

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:



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