Active Query Builder

February 17, 2010

Active Query Builder .NET Edition 1.12 released.

We're glad to announce the new version of Active Query Builder .NET Edition. You can download the newest version or request the trial at the download page.

What's new in the Active Query Builder .NET Edition version 1.12?

• General improvements:
  • New feature: Virtual database objects and fields. It allows to hide complex expressions and sub-queries behind ordinary fields and save derived tables as ordinary database objects. See the Virtual Objects And Fields source code sample for demonstration and details.
  • Metadata and syntax providers for Microsoft SQL Server Compact Edition are made.
  • Re-arranging of criteria list items by drag and drop is implemented. You can drag items using row headers only. To set up the row headers width use the CriteriaListOptions.RowHeaderWidth property.
  • WPF Demo project is added. Active Query Builder is used there in a WPF window through the WindowsFormsHost.
• API improvements:
  • DiagramObjectDeleting event is added. It notifies you that a user are trying to delete an object from the diagram pane and allows to prevent the deletion.
  • New FieldListDescriptionColumnOptions.UseLongDescription property is added to control which description will be shown in the Description column of field lists: if false (default), the MetadataField.ShortDescription is displayed; if true, the MetadataField.LongDescription is displayed.
  • New property LoadJoinsFromWhereClause is added. Using this property you can instruct the Query Builder to not treat WHERE conditions like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded in the Columns pane instead.
  • The new method GetSchemaNames is added to syntax providers to retrieve the list of database schemas.
  • The new properties are added to the QueryBase class to set up unifying operator programmatically: UnionOperator, UnionAllFlag, UnionOperatorFull.
• SQL Syntax fixes and improvements:
  • Sybase and MS SQL Server (only if ServerVersion < MSSQL2005): Support for old-style TransactSQL outer joins: "*=" and "=*" operators is made.
  • MS Access: Bug with unsupported FULL OUTER JOIN is fixed.

» All Active Query Builder news