Active Query Builder History v.3.3.23.1070
- The bug with expanding custom metadata structure items has been fixed. - The crash on searching in the Database Schema Tree has been eliminated. - The bug with not clearing the ORDER BY clause on assigning new text to a sub-query.
Active Query Builder History v.3.3.22.1069
= Parsing of large Oracle SQL queries has been speeded up. + The new Link.ReferencedDataSources property has been added. + The new UserQueriesControl.SelectedItemChanged event has been added. = Creation of referencing loops of virtual objects is not possible now. - Drag'n'drop in the User Queries Control has been fixed. - The bug with presence of the "empty node" item in folders of the User Queries Control has been fixed. - MySQL: Parsing of DateDiff function has been fixed. - The bug with localization of the Add Object Dialog has been fixed. = The new "Execute Query" action has been made in the Full-Featured MDI Demo project.
Active Query Builder History v.3.3.22.1069
= Parsing of large Oracle SQL queries has been speeded up. + The new Link.ReferencedDataSources property has been added. + The new UserQueriesControl.SelectedItemChanged event has been added. = Creation of referencing loops of virtual objects is not possible now. - MySQL: Parsing of DateDiff function has been fixed. - The bug with localization of the Add Object Dialog has been fixed. = The new "Execute Query" action has been made in the Full-Featured MDI Demo project.
Active Query Builder History v.3.3.22.1069
= Parsing of large Oracle SQL queries has been speeded up. + The new Link.ReferencedDataSources property has been added. = Creation of referencing loops of virtual objects is not possible now. - MySQL: Parsing of DateDiff function has been fixed.
Active Query Builder History v.1.28.0
+ Descriptions for database objects and fields are shown in hints in the Metadata Tree. + Minor SQL formatting improvements and bug fixes have been made. = MySQL: Default server version is bumped to v.5.7. = MySQL: The list of valid identifiers has been actualized. + MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been made. = PostgreSQL: The ComparisonOperators syntax provider property now stores only user-defined operators. + PostgreSQL: Support for "$n"-style positional params has been added. - Several fixes for high resolutions have been made.
Active Query Builder History v.1.28.0
+ Constants for new server versions have been added to appropriate syntax providers. + Descriptions for database objects and fields are shown in hints in the Metadata Tree. + On adding a stored procedure (table-valued function), a prompt for its parameters does not appear anymore. Instead, you can open the datasource properties dialog (by selecting the Properties context menu item or by double-clicking on a datasource) and edit procedure parameters there. Those who want to display a dialog on adding a stored procedure can handle the OnGetProcedureParameters to prompt the user for parameters. + The new LinkOptions.DefaultLinkType property has been added. It lets prescribe to create left, right or full outer join instead of inner join on linking tables by drag'n'drop. + The new TSQLBuilder.SubqueryTextFromNewLine propery has been made to break line between the sub-query text and the parentheses enclosing it. + The new group of properties has been made to customize formatting for IF and CASE clauses: TSQLBuilderSelectFormat.ConditionalOperatorsFormat. + Minor SQL formatting improvements and bug fixes have been made. + SQL Text Editor (Professional): The new TextEditorOptions.UseTabCharacter property has been added. - SQL Text Editor (Professional): Some bugs are fixed, minor improvements have been made. + The new OnMetadataTreeNodeGetCaptionText and OnMetadataTreeNodeGetHintText events have been added to customize the text of captions and hints for nodes of the Metadata Tree. = MySQL: Default server version is bumped to v.5.7. = MySQL: The list of valid identifiers has been actualized. + MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been made. = PostgreSQL: The ComparisonOperators syntax provider property now stores only user-defined operators. + PostgreSQL: Support for "$n"-style positional params has been added. + The new SelectListOptions.GridLinesColor property has been added. Being set to clNone it doesn't affect the painting. - DevExpress: Some fixes for dark skins have been made. - Several fixes for high resolutions have been made.
Active Query Builder History v.2.14.0
- Minor link drawing glitches have been fixed. - Client-side programmatic query creation API with aggregates and grouping has been fixed. + PostgreSQL: Support for "$n"-style positional parameters has been added. - Oracle: List of keywords used as valid identifiers has been updated. - MySQL: Some valid identifiers were erroneously treated as keywords. Fixed now.
Active Query Builder History v.3.3.21.1068
- MySQL: Some valid identifiers were erroneously treated as keywords. Fixed now.
Active Query Builder History v.3.3.21.1068
- MySQL: Some valid identifiers were erroneously treated as keywords. Fixed now.
Active Query Builder History v.3.3.21.1068
- MySQL: Some valid identifiers were erroneously treated as keywords. Fixed now. - The bug with selection from the drop-down list of Expression column in the Query Columns List has been fixed.
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!