Active Query Builder ActiveX Edition v.1.27.11
- 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. = Localization files have been updated, missing strings have been added.
Active Query Builder ActiveX Edition v.1.27.10
+ The new property ISelectListOptions.DropdownInExpressionColumn has been added. Turn it off to hide the drop-down list in the Expression column of the Query Columns Grid.
Active Query Builder ActiveX Edition v.1.27.9
- Localization fixes in 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 ActiveX Edition v.1.27.8
= Icons in the Union Navigation Bar and Query Columns List control are correctly scaled now on High DPI monitors. = ODBC: Metadata filters are now applied on loading objects from driver.
Active Query Builder ActiveX Edition v.1.27.3
- The bug with applying result column names for queries with asterisk items when fields aren't loaded yet has been fixed. - Filtration by aggregated columns has been fixed.
Active Query Builder ActiveX Edition v.1.27.2
+ The Custom Expression Editor ellipsis button doesn't hide the combo box button in the inline editor of Expression column in the Query Columns Grid, but displayed next to it. - The bug with incorrect loading of conditions joined with the topmost OR operator has been fixed. - Access violation on pressing the TAB key in an empty Query Columns Grid control with an inactive editor has been fixed. + PostgreSQL, MySQL, SQLite, Netezza: Support for expressions in LIMIT/OFFSET clauses has been added.
Active Query Builder ActiveX Edition v.1.27.1
+ Conditions for the same left part joined using the OR operator are merged into a single cell now. + The new WhereNewLineBefore and HavingNewLineBefore properties have been added to IActiveQueryBuilderX.SelectFormat group to add new lines before the specified types of operators. Possible values are the following: None, TopmostOr, TopmostLogical, AllLogical. - IBM DB2: The bug with appending LIMIT OFFSET by the Query Transformer has been fixed. - Oracle: A workaround for Microsoft ODBC driver bug has been made. Fields are loaded now using the non-parametrized query if the parametrized query fails. - The bug with loading of CTE referred in a reverse order has been fixed. - MS SQL Server: Fake ORDER BY is added correctly now if there is no ordering in the transformed query. - Oracle: Loading of fields for synonyms has been fixed.
Active Query Builder ActiveX Edition v.1.27.0
+ MySQL: Support of MATCH full-text search operator has been added. = DB2: The list of available databases is taken from the driver now. (OLE DB or ODBC). - DB2: The bug with selecting table owner instead of table schema for schema name has been fixed. - Access violation on removing active CTE has been eliminated.
Active Query Builder ActiveX Edition v.1.26.36
- MetadataProvider.LoadFieldsForObjectFromDriver: The TrimQuotes flag is taken into account now. - MetadataContainer.LoadMetadataByFilter: Access violation on calling without a connection while loading objects using events has been eliminated.
Active Query Builder ActiveX Edition v.1.26.35
+ SQLite: Right outer joins are converted to left now. = SQLite: Non-qualified double-quoted identifiers are treated as strings now. - MS SQL Server: Built-in @@-named variables are recognized now. - Oracle: Date/time built-in constants are recognized properly now.
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!