Active Query Builder 2 WinForms Edition History

August 15, 2016

Active Query Builder 2 WinForms Edition v.

+ Criteria Builder: BETWEEN operator is available for string values now.
= DevExpress references are updated to v.16.1.5.

July 25, 2016

Active Query Builder 2 WinForms Edition v.

- PostgreSQL: User-defined prefix operator precendence fix.
- The bug with incorrect determination of datasource on Design Pane for 
  aggregated columns is fixed.

July 13, 2016

Active Query Builder 2 WinForms Edition v.

= QueryColumnsListOptions.UseCustomExpressionBuilder: enabled for all columns
  by default.
- Obey syntax.IsSupportGroupByAlias even for queryies with unions.
- MS SQL Server: New DatePart items are added (ISO_WEEK, TZOffset, ...)
- Informix: Builtin funtions support: YEAR, ... is made.

July 01, 2016

Active Query Builder 2 WinForms Edition v.

+ Query Builder now tries to fix invalid aliases on loading a query.
= DevExpress references are updated to v.15.2.9.
- The UnionSubQuery.Remove method is fixed.
- The bug in MSSQLStyleGrouping mode is fixed.

April 21, 2016

Active Query Builder 2 WinForms Edition v.

+ Oracle: database links are supported now.
= MS SQL Server: Parsing speed is improved.
- DB2: The query to load Primary Key flag for fields is fixed.
= MetadataForeignKey.ReferencedObject works with alternate names now.
- Query Columns List Control: Copying existing expression and pasting 
  it to a new row is fixed. 
- MS SQL: Loading additional information about fields from non-default
  databases is fixed.

April 04, 2016

Active Query Builder 2 WinForms Edition v.

= Metadata retrieval from Sybase IQ works fine now.
- Metadata Filter: correct behaviour on filterItem.Exclude set
- Cross thread error in the Quick Search box of Database Schema View is
- MS SQL Server: Fetching stored procedure parameters from system catalog 
  is fixed.
- DB2: Fetching description for synonyms is fixed.
- Teradata: Fields are sorted by default by ColumnId.

March 23, 2016

Active Query Builder 2 WinForms Edition v.

+ Chinese (Taiwan) translation is added.
= Database Schema Tree: Descriptions for synonyms are taken from referred
  objects if it's not defined for synonym itself.
= Advantage DB: The "use object names as default alias" flag is turned on.
- Trial: Random aliases are kept the same for result query generated by the
  Query Transformer.
- Database Schema Tree: Only field nodes are shown under the table nodes
- Query Transformer: SQL wasn't updated on changing the column.Visible
  property. Fixed now.
- Parsing of the "in (subquery)" expressions in condition cells is fixed.
- The OracleSyntaxProvider.IsSupportSubQueryCTE is set correctly now.
- The error on using Quick search in the Add Object Dialog is fixed.
- The bug with reseting SortType to Ascending after setting the 
  QueryColumnListItem.SetSortOrder property is fixed.

March 02, 2016

Active Query Builder 2 WinForms Edition v.

- StatisticsOutputColumn: Origin* properties calculation for CTE is fixed.
= The UnionSubQuery methods to get parts of the SQL text are published:
  GetSelectClauseString, GetFromClauseString, etc.

February 20, 2016

Active Query Builder 2 WinForms Edition v.

+ Query Statistics: New properties are added to the StatisticsOutputColumn
  class to ease determination of origin of a column in case it comes from
  derived table or CTE: OriginDatasource, OriginMetadataObject and
- Metadata Structure: Custom field nodes in the database schema tree are
  fixed now.
- Setter of the QueryColumnListItem.SortOrder property is fixed.
= MS SQL Server: Parsing performance is improved.
- MS SQL: "COLLATE" reserved word after the column expression is allowed.
- Firebird: Generation of the FIRST and SKIP clauses by QueryTransformer
  is fixed.

February 05, 2016

Active Query Builder 2 WinForms Edition v.

= DevExpress references are updated to v
- Query column with an aggregate wasn't checked on Design Pane. Corrected now.
- SQL Text Editor: The behaviour on pressing Ctrl-Right keys in the end of the 
  text is corrected.

Product Summary

 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!

Social networks