Below is the list of fixes and improvements in Active Query Builder VCL Edition v.220.127.116.11.
+ Now the user can edit Join expression maually via the Link Properties dialog. + DB2, PostgreSQL and ANSI SQL/92: "NULLS FIRST/LAST" support is added. + PostgreSQL: Support of INTO clause is added. + The internal visual controls destroying method is changed. Now all differences between SQL and SyncSQL properties are eliminated. + MS SQL: loading synonyms info for MS SQL 2005 is made. = The component produce an empty query string on empty query builder now. + The new menu item is added to the Union Sub-Query context menu to copy the current union sub query to a new one. + DB2: CONCAT operator is supported now. + Metadata XML schema is updated. = MS SQL Server: The '=true' and '=false' values are treated now as special comparisons for logical expressions only. + Now it is possible to change join type via context popup menu. = Right quotation of conditions in the grid is made. - MySQL: Missing "QUARTER" and "WEEK" functions are added. - MS Access: Quoted parameters parsing is fixed. - InterBase/Firebird: Empty brackets are suppressed now for stored procedures in the FROM clause. + Field descriptions are loaded into metadata container from OLE DB Provider. - Fixed bug with assertion failure when link condition contains sub query. + The User's Guide is updated. + More optimal grid filling is made when loading criteria and select list items. = The "Move forward" and "Move backward" Union Sub-Query context menu items are renamed to the "Move left" and "Move right" for better understanding.
[ Legend: ] [ + New feature ] [ = Improved/changed feature ] [ - Bug fix ] [ ! Important notice ]
You can always get the latest trial version of Active Query Builder VCL 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!