Active Query Builder WinForms Edition v.1.14.2.263
- Oracle: EXTRACT function in XML queries is fixed. - MySQL: missing Group_Conact aggregate function is added. = Polish translation is updated.
Active Query Builder WinForms Edition v.1.14.1.262
- Fixed bug with main query update after CTE changed. - MySQL: RLike and Regexp functions are fixed.
Active Query Builder WinForms Edition v.1.14.1.261
- Fixed parsing of derived tables without alias. - Fixed parsing of joins with parentheses.
Active Query Builder WinForms Edition v.1.14.1.259
+ Arabic (Saudi Arabia) [ar-sa] translation is added. + Swedish [sv] translation is added. - Bug with nested NOT expressions is fixed. - Recursive CTE processing is improved. - MySQL: CONVERT function is fixed. - PlainTextSQLBuilder formatting properties are correctly expanded now (in designer).
Active Query Builder WinForms Edition v.1.14.0.256
- Sql Text Editor: Fixed exception when the suggestion window is visible at the control disposal. - Metadata Editor: Error on creating foreign keys with drag and drop is fixed. - Missing strings for "Collapse" and "Expand" commands are added into "en.xml" translation template file. - Source code examples are updated for compatibility with Visual Studio 2008 and 2010.
Active Query Builder WinForms Edition v.1.14.0.255
= Toolbox Manager is slightly improved (will hasten installation a bit). = German, Spanish, French, Italian and Portuguese(Br) translations are updated. = DevExpress dependencies of ActiveDatabaseSoftware.DevExpressControlFactory.dll are updated to v. 10.2.3.0. = SqlTextEditor and ExpressionEditor: syntax coloring properties go public. + Server version auto-detection is implemented for most of database servers. + Renaming and removing of common table expressions (CTE) is implemented. + Metadata Editor: Adding and editing of virtual objects and fields is made. + Images on tabs are implemented. To hide images use the ShowTabIcons property. To set custom images use the TabsImageList property (must contain 4 images: main query, sub-query, derived table, common table expression (CTE)). - Oracle: Loading of materialized views is fixed. - SqlTextEditor: AVG function highlightning is fixed for MS Access syntax. - 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. - Automatic generation of aliases is fixed.
Active Query Builder WinForms Edition v.1.13.18.254
- Setting "None" to FieldListOptions.SortType now reverts to original fields sort order.
Active Query Builder WinForms Edition v.1.13.18.253
= Metadata Container Load Form: Loading of metadata objects and relations is optimized. - Sybase: Union operators list is fixed. - Oracle: Problem with recursive CTE is fixed. - Oracle: Support of materialized views is added.
Active Query Builder WinForms Edition v.1.13.17.252
+ Italian translation is added.
Active Query Builder WinForms Edition v.1.13.16.250
= Some methods of the Link class goes public. = LoadMetadataHelpers API goes public. - Oracle: DBLinks syntax is fixed. - Oracle: Aggregate functions for Oracle 11 are added. - DevExpressControls: Diagram objects could not be moved outside of the diagram now.
Active Query Builder WinForms .NET Edition:
Active Query Builder WPF .NET Edition:
Active Query Builder ASP.NET Edition:
Active Query Builder Java Edition:
Active Query Builder ActiveX Edition:
Active Query Builder VCL Edition:
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!