Active Query Builder History v.0.4.1
+ Ability to change direction for the control is implemented. (QueryBuilderControl.Direction = ContentDirection.RigthToLeft) + Small make-up for the first column in the Query Columns List is made. - The bug with adding a link to a newly added is fixed. The user have to wait now for the object to be updated at the server side to create a link. - Few minor visual fixes are made.
Active Query Builder History 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 History v.0.4
+ Events to perform specific actions in response to user actions are added. See the list and description in details. + Query Properties dialogs are added for all supported syntaxes. They allow user to change such properties as TOP, LIMIT, DISTINCT and many other. + Several demo projects are added to illustrate various aspects of the component's functionality: Virtual Objects And Fields, Alternate Names, Interacting with ASP.NET controls, Hiding the Diagram Pane. = The SqlEditor.SQL property now retrieves actual SQL query text with changes made by the user in the text editor.
See the full story for details
Active Query Builder History 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 History v.1.15.24
+ Renaming of CTE is possible now. + Caption of the CTE subquery tab is taken from the CTE name now. + Addition of recursive CTE is allowed only for specific servers now. + Query-unique names are generated now for CTE and derived tables. + Server version autodetection for MS SQL, MySQL, Oracle, Sybase ASA/ASE, Informix is made. + Firebird: DateAdd, DateDiff, Overlay, Position builtin functions are added. + Oracle: RANGE added to the list of valid identifiers. + Access: The dollar sign ($) is turned to invalid letter for identifiers, built-in functions are added. + Oracle: Loading of materialized views is made. - Field sorting is reverted to original order now when flsNone value is assigned to the FieldsListOptions.SortType property. - Query properties dialog forms look better now with DevExpress controls. + The new flag functions are added to the TacSubQuery class to determine if a sub-query is derived table or CTE: IsSubQueryDerivedTable, IsSubQueryCTE. + Syntax Providers: The new server flag is added to determine if database server supports recirsive CTE or not: IsSupportRecursiveCTE. = Metadata Loading Wizard: Loading metadata is split to 3 separate stages: Load Objects, Load Relations and Load Custom Aggregates. This allows to bypass the unnecessary steps in case of failure. - Exception on using virtual fields in virtual objects is fixed.
Active Query Builder History v.1.15.24
+ Renaming of CTE is possible now. + Caption of the CTE subquery tab is taken from the CTE name now. + Addition of recursive CTE is allowed only for specific servers now. + Query-unique names are generated now for CTE and derived tables. + Server version autodetection for MS SQL, MySQL, Oracle, Sybase ASA/ASE, Informix is made. + Firebird: DateAdd, DateDiff, Overlay, Position builtin functions are added. + Oracle: RANGE added to the list of valid identifiers. + Access: The dollar sign ($) is turned to invalid letter for identifiers, built-in functions are added. + Oracle: Loading of materialized views is made. - Field sorting is reverted to original order now when flsNone value is assigned to the FieldsListOptions.SortType property. - Query properties dialog forms look better now with DevExpress controls. = Metadata Loading Wizard: Loading metadata is split to 3 separate stages: Load Objects, Load Relations and Load Custom Aggregates. This allows to bypass the unnecessary steps in case of failure. - Exception on using virtual fields in virtual objects is fixed.
Active Query Builder History v.1.2.18.1052
= CTE name editing is enabled in Data Source Properties dialog. - Aliases generation is fixed.
Active Query Builder History v.1.2.18.1050
- Setting getFieldListOptions().setSortType(FieldListSortType.None) now restores the original sort order. - Auto-generated query names and aliases are unique now.
Active Query Builder History v.1.13.18.254
- Setting "None" to FieldListOptions.SortType now reverts to original fields sort order.
Active Query Builder History 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 .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!