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.
What's new in the Active Query Builder .NET Edition version 1.9?
End-user Interface improvements:
Now it is possible to change join type via context popup menu.
Now the user can edit Join expression manually via the Link Properties dialog.
The new menu item is added to the Union Sub-Query context menu to copy the current union sub query to a new one.
The "Move forward" and "Move backward" Union Sub-Query context menu items are renamed to the "Move left" and "Move right" for better understanding.
Now you can invoke the Query Properties dialog with double click on the diagram pane.
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.
The component produce an empty query string on empty query builder now.
More optimal grid filling is made when loading criteria and select list items.
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.
The LoadMetadataDemo is modified. Demonstration of loading metadata from a stored DataSet is added.
New events are added to control adding of new expressions from the query building area (by clicking a checkbox, double-clicking a field or dragging them to the grid): DatasourceFieldAdding, DatasourceFieldAdded.
The new DenyIntoClause property is added to MSAccessSyntaxProvider, MSSQLSyntaxProvider and MySQLSyntaxProvider to allow/deny usage of the INTO clause in SQL queries.
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.
The new property StatisticsOutputColumn.MetadataObject is added.
Two new properties are added to define cardinality of relations between database objects: MetadataRelation.KeyCardinality and ChildCardinality.
SQL Syntax improvements:
PostgreSQL: Support of INTO clause is added.
DB2: Query Properties dialog is added.
MS SQL Server: Ranking functions are supported now.
MS SQL Server: Loading synonyms info for SQL Server 2005 is made.
DB2, PostgreSQL, Firebird and ANSI SQL/92: "NULLS FIRST/LAST" support is added.
Firebird: Empty brackets are suppressed now for stored procedures in the FROM clause.
Oracle: Missing "MONTH", "DAY", "HOUR" and "MINUTE" keywords are added.
Oracle: query builder now loads only metadata objects with granted SELECT right.
Informix syntax: The bug with case sensitivity settings is fixed.
MySQL: Missing "QUARTER" and "WEEK" functions are added.
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!