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.14?
Visual improvements:
Visual building of queries with Common Table Expressions (CTE) is possible now. You may add, link, rename and remove CTE visually.
Ability to collapse and expand the field list using a button at the bottom of each datasource is made.
You may control visibility of this button using the FieldListOptions.ShowCollapseExpandButton property.
Images on tabs are painted now according to sub-query type. To hide images use the ShowTabIcons property.
To set custom images use the TabsImageList property; it must contain 4 images for main query, sub-query,
derived table, common table expression (CTE) respectively.
SQL Text Editor and Expression Editor:
Syntax coloring properties are made public.
Code completion can be disabled now using the DisableCodeCompletion property.
MakeLowercase() and MakeUppercase() methods are added into SqlTextEditor.
Corresponding hotkeys (Ctrl+U, Ctrl+L) and context menu items are made.
Fixed problem with dialog hotkeys in Expression editor.
Localization:
Italian, Spanish and French translations are added.
German, and Portuguese (Brazil) translations are updated.
Demo projects:
The new code example "QueryStructureDemo" demonstrating programmatic SQL query analysis is added.
Metadata Editor:
Adding and editing of virtual objects and fields is made.
Union Navigation Bar:
Empty brackets now will be removed automatically.
Tooltip over the union symbol now shows correct value.
Union operator was changing after some manipulaitons. Fixed now.
Oracle fixes and improvements:
Global pipelined functions can be used in FROM clause and loaded in the metadata tree now.
Loading of materialized views is fixed.
DBLinks syntax is fixed.
Aggregate functions for Oracle 11 are added.
Support for CURSOR() expressions is added.
Loading of metadata relations is optimized.
Other syntax fixes and improvements:
Server version auto-detection is implemented for most of database servers.
Firebird: DateAdd, DateDiff, Overlay, Position built-in functions are added.
MS Access: probelm with '$' char in built-in function names is fixed,
problem with MS Excel sheet names quotation is solved.
Other fixes:
Memory leaks in visual mode are fixed.
Automatic generation of aliases is fixed.
Installation package:
Toolbox Manager is improved to hasten the installation process.
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!