Active Query Builder VCL Edition 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 VCL Edition v.1.27.12
+ DB2: Database objects description fetching for iSeries/AS400 has been made. = NexusDB 4: Package references are updated to the latest version 4.12. - MS SQL Server: Query Properties forms compilation for DevExpress controls has been fixed.
Active Query Builder VCL Edition v.1.27.11
- Query Transformer: The bug with creation of filter expression for a column with quoted aliases has been fixed. - The bug with removing a derived table via the context menu command has been fixed. - PostgreSQL: Parsing of string literals with ''-quoted apostrophes has been fixed. + MS SQL Server: Support of SELECT into local var (SELECT @localVar = 10) has been added. - Several DevExpress controls UI bugs have been fixed. - Compilation of Metadata Provider for DOA has been fixed. + Criteria Builder: The new ReadOnly and Color properties have been added. + Criteria Builder: Minor bug fixes and improvements have been made. - The "Field not found" bug in Criteria Builder has been fixed. - Text Editor: Selection movement on indent/unindent commands has been eliminated. - Text Editor: The bug in Replace command in selection has been fixed. = Localization files have been updated, missing strings have been added.
Active Query Builder VCL Edition v.1.27.10
+ The new TacQueryBuilder.SelectListOptions.DropdownInExpressionColumn property has been added. Turn it off to hide the drop-down list in the Expression column of the Query Columns Grid. - Localization of TacCriteriaBuilder has been fixed. - Installer: Folder for the demo projects can be changed now.
Active Query Builder VCL Edition v.1.27.9
- SQL Text Editor: Localization of the Find & Replace form has been made. - Localization fixes in the Properties forms have been made. - Correct column prefix is emitted for procedures and table-valued functions. - Minor memory leaks have been eliminated.
Active Query Builder VCL Edition v.1.27.8
= Icons in the Union Navigation Bar and Query Columns List control are correctly scaled now on High DPI monitors. = FireDAC: Metadata filters are now applied on loading objects from driver. - Professional: Source code compilation with DevExpress controls has been fixed.
Active Query Builder VCL Edition v.1.27.7
! Demo projects are installed now to the All Users Profile directory: C:\Users\Public\Documents\ActiveDBSoft\Demos\ - Source code in Professional version has correct compiler defines now. - Installer: An option to extract packages for all supported Delphi versions has been made. - SQL Text Editor: A memory leak has been fixed. - SQL Text Editor: Font is scaled correctly now on high resolutions. = The SQLTextEditor.ParentFont property has been made public.
Active Query Builder VCL Edition v.1.27.6
- Expression Editor: Access violation on moving mouse over the query objects tree has been eliminated.
Active Query Builder VCL Edition v.1.27.5
+ Professional: SQL Text Editor: packages for RAD Studio XE have been added. + Professional: Expression Editor: The new properties Height and Width determine the dialog size. + Professional: SQL Text Editor: Font scaling has been made. - Professional: Expression Editor: Access Violation on mouse move over metadata tree has been fixed. = Various fixes and improvements in the Full-featured demo have been made.
Active Query Builder VCL Edition v.1.27.4
- Compilation errors for C++Builder have been fixed. - Minor fixes for the Full-featured demo project have been made. ! Demo projects are moved to the %ALLUSERSPROFILE%\Documents\ActiveDbSoft\Demos" folder (usually "C:\Users\Public\Documents\ActiveDBSoft\Demos".
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!