Below is the list of fixes and improvements in Active Query Builder WinForms Edition v.22.214.171.124.
+ New properties in the QueryBuilder and PlainTextSQLBuilder components: AsKeywordInExpressionAlias and AsKeywordInObjectAlias. You can use them to force the query builder to always show or omit AS keyword before aliases. + The new events DatasourceFieldRemoving, DatasourceFieldRemoved are added to control removal of fields by unchecking them from the datasource field list. + Basic support for custom aggregate functions is implemented. + MSSQL: Custom aggregate functions retrieval is made. + Oracle, PostgreSQL: Interval literals are supported now. + The INNER keyword can be omitted now in join specifications for Firebird and MSSQL via the InnerKeywordInLinks property. = (!) API changes: MetadataFieldNameList class is renamed to MetadataQualifiedNameList. - The CROSS JOIN processing bug is fixed. - Wrong link context menu coordinates when the diagram pane is scrolled down are fixed.
[ Legend: ] [ + New feature ] [ = Improved/changed feature ] [ - Bug fix ] [ ! Important notice ]
You can always get the latest trial version of Active Query Builder WinForms Edition at the download page.
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!