Active Query Builder .NET Edition 1.1.6 released

We're glad to announce the new minor version of Active Query Builder .NET Edition. You can download the free version or request trial at the download page.

What's new in the Active Query Builder .NET Edition 1.1.6?

General Improvements

Significantly increased speed of working.
Ability to localize the component is implemented.
Assemblies no allow partially trusted callers.
VB.NET sample application is added.
Non-Visual sample project is updated.

SQL Parsing Improvements

DB2 Syntax and Metadata Providers are added. ^*
MySQL Syntax and Metadata Providers are added. ^*
Numbers in scientific notation are supported now.

Programming API improvements

New QueryBuilder.LayoutSQL property is added. It allows to save and restore the SQL query and the layout of data source objects on the diagram pane.
New UnionSubQuery properties allowing to get all query clauses in the text form: UnionSubQuery.SelectListString, UnionSubQuery.FromClauseString, UnionSubQuery.WhereClauseString, UnionSubQuery.GroupByClauseString, UnionSubQuery.HavingClauseString, UnionSubQuery.OrderByClauseString.

SQL Parsing bug fixes

Fixed bug with wrong quotation of SQL functions in QuoteAllIdentifiers mode.
Removed unwanted object prefixes in the metadata tree and Add Object form.
Removed unwanted object prefixes in the caption of the data source window.
Fixed bug with unsupported JOIN clauses in Oracle 8i.

Other bug fixes

Splitter of the query structure tree went wrong side after making the tree visible.
Fixed wrong drawing of Access style links (arrows on the opposite side).
Query structure tree didn't refresh when the query builder becomes visible. Fixed.
Query statistics didn't show fields for offline tables. Fixed.

^* - these features will be available in the Standard version of Active Query Builder only.

Author: Sergey Smagin at ActiveDBSoft.

News

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