Downloads

Active Query Builder 2 WinForms Edition History

February 24, 2014

Active Query Builder 2 WinForms Edition v.2.7.3.632

+ Criteria Builder: The new SkipInvalidValues property is added to allow query
  generation ignoring unfilled and invalid conditions.

February 20, 2014

Active Query Builder 2 WinForms Edition v.2.7.2.631

= All types of query parameters are enabled now for all syntaxes.
= Appearance of multi-links in the Add Linked Objects menu is improved.
- The Virtual Objects And Fields example is corrected.

February 18, 2014

Active Query Builder 2 WinForms Edition v.2.7.2.630

= The Add Linked Objects menu now has separate items for each link if there are
  multiple links to the linked object.
- Fetching comments for MSAccess, PostgreSQL, MySQL, Firebird and DB2 is fixed.
- Query Transformer: Filtration by column with aggregate is fixed.

January 29, 2014

Active Query Builder 2 WinForms Edition v.2.7.2.627

- Query Transformer: Filtration by columns with analytic expressions is fixed.
- DevExpressControlFactory: The DataSourceOptions.ShowDescriptionTooltips and
  DataSourceOptions.DescriptionTooltipsDelay properties are fixed.

January 27, 2014

Active Query Builder 2 WinForms Edition v.2.7.2.626

+ QueryTransformer: The new ExportToXML() and ImportFromXML() methods are 
  added to allow serialization of transformations to XML.
+ The new MetadataLoadingOptions.DisableAutomaticMetadataLoading property 
  is made to let disabling of automatic metadata loading on query parsing.
+ The new properties are added to control description tooltips over the
  datasources and database schema tree.
  The ShowDescriptionTooltips and DescriptionTooltipsDelay properties are
  added to the DataSourceOptions and DatabaseSchemaTreeOptions groups.
- QueryTransformer: Column expression is used in WHERE clause instead of alias.
= Documentation is updated.

January 21, 2014

Active Query Builder 2 WinForms Edition v.2.7.1.624

- MS SQL Server: Loading of metadata object descriptions is fixed.
= The ClearSearchBox() method now acts immediately (was delayed).
= Search related methods IsSearching(), StopSearch(), ClearSearchResults() are
  made public.

January 20, 2014

Active Query Builder 2 WinForms Edition v.2.7.1.623

+ Virtual objects and fields are present in the Query Statistics among with 
  real objects expanded from virtual objects. 
  The new IsFromQuery and IsFromVirtual boolean properties are added to 
  StatisticsDatabaseObject and StatisticsField classes. 
  The IsFromQuery property is true if an object explicitly present in the query,
  the IsFromVirtual property is true if an object is expanded from a virtual
  object. Both properties can be set to true at a time if an object exists in
  the query in both ways.
+ Add Object Form: The "Show all objects..." item is shown among with the list
  of metadata structure nodes (usually namespaces). Double clicking on it
  displays flat list of all underlying objects.
+ The ClearSearchBox() public method is added.
= Universal Metadata Provider: The "TABLES" schema table is used now to fetch
  metadata.
- Clearing text in the search box before start of the search process is fixed.
- The bug with improper virtual objects alias expanding in column references
  is fixed.

January 14, 2014

Active Query Builder 2 WinForms Edition v.2.7.0.621

+ Search is made in the Add Object form.
= DevExpress references are updated to v.13.2.6.0.
- Query builder was showing default icons in the search results instead of icons
  set by user in the MetadataStructureOptions. Fixed now.

December 30, 2013

Active Query Builder 2 WinForms Edition v.2.6.3.620

+ Search in the database schema tree is made.
+ The new properties are added to the DatabaseSchemaTreeOptions:
  SearchBoxVisible, SearchBoxDocking.
+ Alternate names are added to the query structure XML
  (QueryBuilder.Query.StructureXML).

December 20, 2013

Active Query Builder 2 WinForms Edition v.2.6.1.618

+ The new PaintDesignPaneToBitmap() method is added for exporting the design pane
  content to an image.