Active Query Builder ActiveX Edition v.1.15.12
+ German translation is updated. + French translation is updated. - MS SQL Server: Special chars in parameter names (_,@,...) are accepted now. - Interbase: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP are supported now. + Derived table alias is shown in the query structure tree instead of entire SQL text.
Active Query Builder ActiveX Edition v.1.15.7
+ New internal methods to work with datasets are made. Now most of metadata retrieval requests return results in unidirectional read-only datasets. - MS SQL Server: Char and Nchar built-in functions parser ambiguity is fixed. - Firebird/InterBase: Parsing queries with parentheses in FROM clause are fixed. - CTE in derived tables are fixed one more time. - Splitter behavior is changed to update it's position immediately.
Active Query Builder ActiveX Edition v.1.15.6.0
+ Oracle: Global pipelined functions can be added from the database objects tree to the query building area. - More reliable object prefix skipping and names fixup in derived tables is made.
Active Query Builder ActiveX Edition v.1.15.5.0
+ Small SQL92 grammar fixes are made.
- The component doesn't generate empty string anymore if WITH clause items
exist in a query.
- PropertiesXML property setter is fixed.
- Wrong name references fixup in CTE subqueries is fixed.
- Wrong links relocation in complex FROM clauses with many parentheses on
datasource/link deletion is fixed.
- MS SQL Server: Field aliases for table-valued functions are allowed now.
("select t.f1, t.f2 from TVF() as t(f1,f2)")
Active Query Builder ActiveX Edition v.1.15.4.0
+ Better support of recursive CTE is made. - The problem with returning wrong object type from the FieldsListOptions properties under Internet Explorer is fixed.
Active Query Builder ActiveX Edition v.1.15.3.0
- MS Access: Built-in function names are removed from the list of correct
identifiers.
- Assertion failure error when you use alias same as object name is fixed now.
(select * from Orders Orders)
- A better fields list in WITH clause support is made.
+ List of existing Common table expression is added to the "Add CTE" submenu.
+ SQLite: Support of string concatenation operator is made ("qwe" || "asd")
= Informix: Better server autodetection is made.
Active Query Builder ActiveX Edition v.1.15.0.0
+ Now it's possible to add Common Table Expressions visually using the context menu item of the query building area. + Wheel scrolling in field lists is made. = The ParenthesizeSingleCriterion property is applied now to join conditions. - Bug fixed: Wrong names fixup for select items like "table.*" if more than one "table" objects were used in the query. - Firebird: Parameter names can use the '#' symbols now. - The WorkOffline property wasn't taken into account when loading fields for stored procedures. Fixed now. - MS Access: Bug with unsupported FULL OUTER JOIN is fixed. - PostgreSQL: The list of unifying operators is fixed. - MS Access: "NULL" is excluded from the list of valid identifiers. - DAX error is fixed one more time.
Active Query Builder ActiveX Edition v.1.14.14.0
+ Spanish and russian translations are updated.
+ The new property is made to accept tabs in the columns pane.
IActiveQueryBuilderXControls.SelectListOptions.AcceptTabs: VARIANT_BOOL
(default true)
+ Firebird: "IS DISTINCT FROM" operator is supported now.
+ Signed .Net interop assemblies are added to the installation package.
+ MS SQL Server, Sybase: Support of the old-style TransactSQL outer join
operators ("*=" and "*=") is made.
+ Aliases for virtual calculated fields are added automatically now if they
aren't defined by the user.
+ The new property IActiveQueryBuilderX.MetadataXmlFile is added to be able to
define it without JavaScript coding.
+ Firebird: Predefined context variables are supported now: CURRENT_DATE,
CURRENT_TIME and CURRENT_TIMESTAMP.
- The component doesn't trim right spaces when creating field's aliases from
alternate names now.
- MySQL: Better support of CONVERT function is made.
- PostgreSQL: Metadata filtration is fixed.
- The LayoutSQL property does not expand virtual fields and objects now.
- Create derived table access violation is fixed now.
- Sybase ASE: Relations metadata loading is fixed now.
- Assertion failed when syntax provider is changed. Fixed now.
Active Query Builder ActiveX Edition v.1.14.4.0
+ New feature: Virtual database objects and fields. It allows to hide complex expressions and sub-queries back of ordinary fields and save derived tables as ordinary database objects. + New properties are added to support virtual database objects and fields: IMetadataField.Expression and IMetadataObject.Expression (BSTR). IMetadataField.Expression can contain any correct SQL expression; IMetadataObject.Expression can contain any correct "datasource": an SQL expression which can be used in the FROM clause, i.e. object name, subquery (derived table), etc. The component will replace all mentions of such fields and objects in result SQL with this expression. Read the IActiveQueryBuilderX.SQLForServer property to get the expanded result SQL text. + The new property IActiveQueryBuilderX.LoadJoinsFromWhereClause: VARIANT_BOOL is added. Using this property you can instruct Query Builder to not treat expressions like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded as generic WHERE clause expressions instead. - Metadata relations loading from Sybase ASE is fixed. - The IActiveQueryBuilderX.TreeOptions.TreeWidth and IActiveQueryBuilderX.TreeOptionsMetadata.TreeWidth properties are reflect changes in UI immediately now. - DB2: Metadata filtering is fixed. - Subquery tab doesn't disappear when user closes a derived table. Fixed now.
Active Query Builder ActiveX Edition v.1.13.21.0
+ Unambiguous reading metadata from XML generated by other AQB Editions
(.Net, Java) is made.
+ The new IFieldsListDescriptionColumnOptions.ShowLongDescription property
is added to control which description will be shown in the Description column
of the fields list:
when it's False (default), the IMetadataField.ShortDescription is shown;
when it's True, the IMetadataField.LongDescription is shown.
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!