Active Query Builder ActiveX Edition v.1.26.34
= Automatic links creation has been improved: links are created only from Parent to Child table or vice vera, but not both at the same time. + PostgreSQL: Support of materialized view, TOAST tables, and foreign tables has been made. + Oracle: Support of the "AT TIME ZONE" clause has been added. + Firebird: Column name definition after alias in the FROM clause is supported now. + IBM DB2: The ListAgg function is supported now. + IBM DB2: The QSYS2 tables are used now for fields loading if this scheme exists. Several minor bugs have been fixed. + SQLite: Support for the IS operator ("expr IS expr") has been added. - SQLite: The bug with not loading fields for a table being added second to the query has been fixed. - MS SQL Server: loading objects from non-default schemas for non-default databases is fixed - MS SQL Server: The DATEADD parser unambiguity has been fixed. - MySQL: Parsing of DATE, TIME and DATETIME types as keywords has been fixed.
Active Query Builder ActiveX Edition v.1.26.33
= Debug version improvements have been made. - The bug with the newly introduced PartialMetadataLoading property is fixed. - DB2: Parsing of the CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP constants has been fixed.
Active Query Builder ActiveX Edition v.1.26.32
- The bug with the newly introduced PartialMetadataLoading property is fixed. - MySQL: Proper fix up of string aliases has been made to avoid control hang on some queries.
Active Query Builder ActiveX Edition v.1.26.31
- Loading metadata from XML has been fixed.
Active Query Builder ActiveX Edition v.1.26.30
+ The new IActiveQueryBuilderX.PartialMetadataLoading property has been added. Setting it to True prescribes the component to load metadata only for objects that were used in the query on assigning it to the SQL property. + Mouse wheel works now in pick up lists of the Query Columns Grid. + The MetadataContainer.LoadFromXML method is significantly speeded up. - Firebird: Support of aliases in the ORDER BY clause only for the version 2.0 and higher. - MS SQL Server: List of valid identifiers list has been updated. - Single-line comments are recognized properly now.
Active Query Builder ActiveX Edition v.1.26.29
+ Scrolling by mouse wheel now works in the drop-down pick list of the Expression cell editor. = The FieldListDescriptionColumnOptions.ShowLongDescription property is now set to True by default. = Minor column type painting improvements in datasource field lists have been made. - Calculation of checked fields in datasource field lists has been fixed. - The Varchar(Max) and Varbinary(Max) types are displayed correctly now. - MS Jet: Excel sheet names with the dollar sign are supported now. - Oracle: Support for the special form of TRIM function has been added. - MS SQL Server: ROW and ROWS are added to the list of valid identifiers. - Other minor bugfixes and improvements have been made.
Active Query Builder ActiveX Edition v.1.26.28
+ Query Transformer is now capable to rename output query columns. + The new property aqbxQueryTransformer.RenameDuplicatedColumns property prescribes to explicitly specify all the columns in the query SELECT list by expanding the asterisk items, then find and rename unnamend and duplicated column names (default = false). + The new aqbxQueryTransformer.AlwaysExpandColumnsInQuery instructs to perform asterisk expansion in the query SELECT list even if it's not needed for the specified query transformations (default = false). ! The aqbxOutputColumn.Name property is renamed to OriginalName. + The new aqbxOutputColumn.PreassignedName allows to specify the needed name for a query output column. + The new aqbxOutputColumn.ResultName gets the result query columns name which turned out as a result of automatic columns renaming routine and manual appliance of the new name specified via the PreassignedName property. - QueryTransformer: The bug with sorting by a column , which alias is equal to field name is fixed. - The "Build Expression" popup menu item is now shown only when a handler is assigned to the OnCustomExpressionBuilder event. - MS SQL Server: CHAR(n) parser ambiguity is fixed. - MS SQL Server: CHAR and NCHAR are moved from the builtin functions to the list of valid identifiers. + PostgreSQL: Support for custom aggregate functions is added. - PostgreSQL: Date/time parts are added to the list of valid identifiers.
Active Query Builder ActiveX Edition v.1.26.26
- Query Columns Grid: Changes in inplace editors are committed on focus lost. - PostgreSQL: Parsing of set operators is fixed.
Active Query Builder ActiveX Edition v.1.26.25
- SQLite: Support for CHAR builtin function is added.
Active Query Builder ActiveX Edition v.1.26.24
- Parsing of queries with grouping or ordering by integer constants is fixed. (treat them as column references) = Query Columns List: Inplace editor is still visible now when focus is lost. - PostgreSQL: User-defined prefix operator precedence is 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!