Active Query Builder WinForms Edition v.1.8.5.163
- Oracle: query builder now loads only metadata objects with granted SELECT right. - Bug with SubString function is fixed.
Active Query Builder WinForms Edition v.1.8.5.162
+ 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.
Active Query Builder WinForms Edition v.1.8.4.159
+ 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.
Active Query Builder WinForms Edition v.1.8.2.155
+ 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.
Active Query Builder WinForms Edition v.1.8.2.154
+ 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.
Active Query Builder WinForms Edition v.1.8.1.152
+ 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.
Active Query Builder WinForms Edition v.1.8.0.149
+ 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.
Active Query Builder WinForms Edition v.1.8.0.146
- Missing "extract" function is implemented in Oracle syntax. - Missing "model" keyword in Oracle syntax is added.
Active Query Builder WinForms Edition v.1.8.0.145
+ New properties are added to take control over the links creation process: QueryBuilder.LinkOptions: - 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.
Active Query Builder WinForms Edition v.1.7.9.144
- The bug in component disposing is fixed. - Oracle syntax: "ZONE" is now treated as valid identifier.
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!