Active Query Builder .NET Edition 1.18 is released
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.18?
SQL Text Editor changes:
Tab and Shift-Tab hot keys now shift the selected text block left and right.
Mouse and keyboard selection behavior is fixed.
Reaction on selected text clicking is changed.
Text selection was disappearing on undo/redo operations. Fixed now.
"GROUP BY" and "ORDER BY" clauses are added to the suggestion list as templates so they might be entered at one click.
Other minor improvements and bug fixes are made.
General changes:
Select item alias is used as subquery tab caption now.
Conditions like "a > 1 and a < 3" now loaded into the same criteria cell.
The LayoutXML now saves and restores the collapsed state of datasource objects.
The Query Statistics output columns collection now stores column aliases without quotes.
Double clicking on a datasource column moves focus to the first criteria cell of the newly added criteria item.
SQL syntax improvements:
Support for Teradata Database SQL syntax is made.
Oracle: optimizer hints are supported now.
MS SQL Server: Support of varchar(max) is added.
PostgreSQL: Support for analytic expressions is made.
PostgreSQL: Support for typed literals: "date '2001-09-28'", "integer '7'" is added.
API improvements:
The new properties are added to StatisticsOutputColumns class: DataSource, ObjectNameInQuery, ColumnNameInQuery.
The new events are added to the SqlTextEditor to allow overriding of default drag and drop behaviour: PreProcessDragOver, PreProcessDragDrop, PreProcessDragEnter, PreProcessQueryContinueDrag.
The new CriteriaListOptions.BackColor property is made.
The new properties are added to set backgroud color for different parts of UI: QueryStructureTreeOptions.BackColor, MetadataTreeOptions.BackColor, DiagramPaneColor.
The new LinkChanging and LinkChanged events 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!