We're glad to announce the new version of Active Query Builder .NET Edition. You can download the newest version or request the trial at the download page.
Major improvements of the new version 1.8 are the following:
General improvements:
Conversion of ANSI JOIN clauses to WHERE expressions is made when Syntax changed to one which doesn't support ANSI joins.
German translation is added.
The new look of Expression column dropdown list is made.
New datasource context menu items are added to check/uncheck all fields for a datasource.
Criteria list control now automatically convert manually entered conditions like 'null', '=null', '<>null', etc. to 'Is Null' and 'Is Not Null' phrases.
New sample project is added. The EventsDemo demonstrates using of few useful events to get control over the query building process.
The new demo for Delphi Prism is added.
API improvements:
The new FlatBorders property makes most of controls have single (flat) border.
The new property CriteriaListOptions.DisableDirectEditingIn is added to disable manual editing of the Expression and Criteria columns.
The new QueryBuilder.LinkOptions group of properties is 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.
The new FieldListDrawItem event is added. It allows to customize drawing of field lists.
The new LinkDragOver event is added.
New event is added to customize captions of datasources at the query building area: QueryBuilder.CustomizeDatasourceCaption.
The new event CustomizeDatasourceFieldList is added for sorting or modifying the content of field list controls.
New events are added to control displaying of the properties dialogs: QueryBuilder.BeforePropertiesDialog and QueryBuilder.AfterPropertiesDialog.
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.
SQL Syntax fixes and improvements:
Parameters parsing in MSSQL and Oracle syntaxes is improved.
Oracle: Missing "EXTRACT" function and "MODEL" keyword in Oracle syntax are added.
Oracle: "ZONE" is now treated as valid identifier.
Oracle: Wrong aggregate names are corrected.
DB2: Fixed problem with retrieval of the current schema for AS/400.
MySQL: Bugs with "IF" and "REPLACE" builtin function are fixed.
MSSQL syntax provider was unable to retrieve native field datatypes from views. Fixed now.
General bug fixes:
The bug in component disposing is fixed, some memory leaks are eliminated.
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!