Active Query Builder History v.1.16.18
+ SQLite: The component can load foreign keys now. = SQLite: The list of aggregates and built-in functions is filled now. + The new TacQueryBuilder.LinkOptions.CreateLinksByIdenticalFieldNames property is added to instruct the component to add links between objects by identical field names (might be useful for legacy databases without foreign keys). + The new TacBaseSyntaxProvider.CreateWhereJoinsByDefault property is added to instruct the component to create joins in WHERE clause, not using the JOIN keyword in FROM clause. Useful for Oracle databases when you want to use Oracle style joins (+=, =+). = Preserving additional ORDER BY attributes like "ORDER SIBLINGS BY" is made. = Turkish.lng: correct order of params in "Unexpected token" error message - Localizer "out of range" error when saving files is fixed. - The component will not try to load fields from database now if they already loaded during execution of the DoObjectMetadataLoading event handler. - MS SQL Server: Support of the OPENQUERY function is fixed. - Few CTE bugs are fixed.
Active Query Builder History v.1.16.18
+ SQLite: The component can load foreign keys now. = SQLite: The list of aggregates and built-in functions is filled now. = Preserving additional ORDER BY attributes like "ORDER SIBLINGS BY" is made. = Turkish.lng: correct order of params in "Unexpected token" error message - The component will not try to load fields from database now if they already loaded during execution of the ObjectMetadataLoading event handler. - MS SQL Server: Support of the OPENQUERY function is fixed. - Few CTE bugs are fixed.
Active Query Builder History v.0.5.3
+ Separate solution files are added for every source code example. - GUI bug with FireFox 4 is fixed.
Active Query Builder History v.0.5.2
+ The new demo project is added to demonstrate fetching of the query results. Please note that this functionality is not a part of the component, but included in this demo only upon user's requests. - The bug with wrong width of expression editor in Chrome is fixed.
Active Query Builder History v.1.14.9.296
+ The new CreateWhereJoinsByDefault property is added to all syntax providers. Setting it to true instructs the component to create joins in WHERE clause instead of using ANSI joins. Note that the ANSI joins still may be created if the user will make an OUTER JOIN. For Oracle syntax, the component will create Oracle-style joins (+=, =+) except FULL OUTER JOIN. - Oracle: The bug with ORDER SIBLINGS BY clause is fixed.
Active Query Builder History v.1.14.8.293
- Focused data source control painting bug in Windows XP is fixed. - Expression Editor: Suggestion popup list painting at 120 DPI is fixed.
Active Query Builder History v.1.16.16
= Language files are converted to UTF8. The component allows to read language files in both ANSI and UTF8 encoding now. - OleInitialize/OleUnintialize calls are corrected for C++ Builder support. - Wrong SQL generation when object and database names are equal is fixed.
Active Query Builder History v.1.16.16
= Language files are converted to UTF8. The component allows to read language files in both ANSI and UTF8 encoding now. - Wrong SQL generation when object and database names are equal is fixed. - The bug with using CustomExpressionEditorParams.CompletionsList is fixed.
Active Query Builder History v.1.14.8.292
+ The new property FieldListOptions.CollapseExpandButtonLocation is added. It allows you to specify the location of the Collapse/Expand button (at the top or bottom of each datasource). = All forms are optimized for 120 DPI display setting.
Active Query Builder History v.1.16.12
+ The new property TacSQLBuilder.CTESubQueryFormat is made to define formatting rules of CTE sub-queries independently from derived tables. - Better parsing of criteria expressions is made. + The new events are added to customize the result SQL query text: TacSQLBuilder.OnBeginBuildSQLForNode and TacSQLBuilder.OnEndBuildSQLForNode = The AddNewCTE method performs names fixup for its AQuery argument now. + The new property TacMetadataContainer.LoadInvertedRelations is added to get relations assigned to the detail table instead of master table while loading metadata.
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!