Below is the list of fixes and improvements in Active Query Builder 2 WinForms Edition v.188.8.131.524.
+ The new feature "User Queries" is added to allow for creation of reusable virtual objects containing a previously saved query. + The new "Reusable Queries" pane is added below the Database Schema Tree. Use the PanesConfigurationOptions.UserQueriesPaneVisible property to show/hide this pane. To save and load ueser queries use import/export methods of the QueryBuilder.UserQueries object. + The Show Query By Parts demo is replaced with the improved SubQuery Results Preview demo. + Query Transformer now supports Skip() with ROW_NUMBER ranking function for DB2 and MS SQL Server 2005-2008. + MS Access: Query Transformer is able to use Limit() with MS Access now. - MS SQL Server: The mistyped DATETIMEOFFSETFROMPARTS function name is corrected. - DevExpress: Crash on Delete command of the CTE tab context menu is fixed. - The bug on closing last datasource in CTE is fixed.
[ Legend: ] [ + New feature ] [ = Improved/changed feature ] [ - Bug fix ] [ ! Important notice ]
You can always get the latest trial version of Active Query Builder 2 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!