Active Query Builder ActiveX Edition v.1.30.4
+ Users now can create links from UI separately indicating the beginning and end field via the datasource field context menu. + The new property ActiveQueryBuilderX.SwapSidePanels has been added to swap the Database Schema Tree and the Query Structure Tree. = PostgreSQL: Backslash quotation for generic string literals has been removed.
Active Query Builder ActiveX Edition v.1.30.3
= Design Pane: Datasource captions are made more contrast. = Usability of building queries with grouping has been improved by a series of small fixes. + Oracle: params and fields for stored procs, table functions loading fix = Oracle: Synonyms are loaded faster now. - Oracle: The bug in the QueryTransformer that led to incorrect query generation has been fixed. - SQL Server: Loading field comments for objects from non-default schemas and databases has been fixed. + PostgreSQL: Support for the WINDOW, FILTER clauses has been added. + SQLite: Support for the WINDOW and FILTER clauses and analytic expressions has been added. = SQLite, Teradata: Support for the REPLACE function has been fixed. = SAP Hana: Support for TOP and PLACEHOLDER clauses, NVARCHAR builtin type, CURRENT_UTC* constants have been added. + SAP Hana: Metadata filters are applied now to metadata fetching queries. - SAP Hana: Working with table functions has been fixed.
Active Query Builder ActiveX Edition v.1.30.2
- The unhandled exception on component destruction has been eliminated. - Universal SQL syntax: The bug with TIMESTAMPADD and TIMESTAMPDIFF functions is fixed.
Active Query Builder ActiveX Edition v.1.30.1
+ The new paramValue.ParamsCount and paramValue.Params[index] properties are added to provide a reference to corresponding items of the Parameters collection which might be needed to detect the related field, object, and type for the parameter value. + The new paramValue.Expression property has been added to replace parameters with SQL expressions in the SQL query text. ! The ParameterValuesCanBeMacros property has been removed. + SAP Hana & ANSI Standard SQL Syntax: Support for the standard TRIM(LEADING/TRAILING ...) builtin function is added. - Oracle: Paging with ROWNUM has been fixed. - MySQL: Parsing of the MATCH full-text search expressions has been fixed.
Active Query Builder ActiveX Edition v.1.30.0
+ Now you can assign an SQL script with DECLARE and SET statements preceding the SELECT query to the ActiveQueryBuilderX.FormattedSQL property. The component will bypass statements preceding the first SELECT statement, lets you edit the SELECT statement and get back the script with the preceding statement and the modified SELECT statement. + The new properties ActiveQueryBuilderX.ParameterValues* are made to: 1. cut off conditions with undefined parameter values, 2. apply parameter values (scalar and lists where it's possible), 3. replace parameters with SQL expressions in the query text. = Query Columns List: Handling of incomplete strings in expression cells has been improved. - PostgreSQL: Support for WITH clause in subqueries has been added.
Active Query Builder ActiveX Edition v.1.29.11
- Minor bugs in the Query Structure Tree have been fixed. + Oracle: OFFSET/FETCH support for Oracle 12+ + PostgreSQL: add DISTINCT ON support = New properties have been added to ANSI standard and Universal syntax providers: IsSupportDatabases and IsSupportSchemas. = Informix: Support for new built-in functions (LEFT, RIGHT) has been added. + Informix: Support for derived tables for IDS11+ has been made. = Informix: Objects from all schemas can be used without schema prefix. - PostgreSQL: Comparison operators precedence has been corrected. = PostgreSQL: Handling of "partial" expressions like "=1" is improved. - PostgreSQL: Filtration of camel-cased names using QueryTransformer has been fixed. - Pervasive: The bug with a dot before the table name has been fixed.
Active Query Builder ActiveX Edition v.1.29.10
- The bug with an empty schema for generic ANSI SQL syntax providers has been fixed.
Active Query Builder ActiveX Edition v.1.29.8
- Dot-prefixing objects with an empty schema for servers without database namespace support has been fixed.
Active Query Builder ActiveX Edition v.1.29.7
+ Query Structure Tree: sub-queries from WHERE and SQL expressions from other parts of the query are shown in the tree now. = AST tree operations have been speeded up.
Active Query Builder ActiveX Edition v.1.29.6
= New server versions are listed now for MySQL, MS SQL, Oracle syntaxes. = Link Properties Form: The single-line expression editor has been replaced with a memo field. - Visibility of the UnionNavBar is restored correctly now after updating the UnionTabSheet params. - SAP SQL Anywhere: Loading of objects for a non-privileged user has been fixed; modern views are used now for v.17 and higher. - Universal Syntax Provider: The detection of database and schema namespaces usage is performed now. It now works fine with the Absolute DB. - SQLite: Union operators 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!