Downloads  »  Active Query Builder ActiveX Edition History

May 15, 2009

Active Query Builder ActiveX Edition v.1.11.20.0

Below is the list of fixes and improvements in Active Query Builder ActiveX Edition v.1.11.20.0.

+ Now the user can edit Join expression maually via the Link Properties dialog.
+ DB2, PostgreSQL and ANSI SQL/92: "NULLS FIRST/LAST" support is added.
+ PostgreSQL: Support of INTO clause is added.
+ The internal visual controls destroying method is changed. Now all 
  differences between SQL and SyncSQL properties are eliminated.
+ MS SQL: loading synonyms info for MS SQL 2005 is made.
= The component produce an empty query string on empty query builder now.
+ The new menu item is added to the Union Sub-Query context menu to copy the
  current union sub query to a new one.
+ DB2: CONCAT operator is supported now.
+ Metadata XML schema is updated.
= MS SQL Server: The '=true' and '=false' values are treated now as special
  comparisons for logical expressions only.
+ Now it is possible to change join type via context popup menu.
= Right quotation of conditions in the grid is made.
- MySQL: Missing "QUARTER" and "WEEK" functions are added.
- MS Access: Quoted parameters parsing is fixed.
- InterBase/Firebird: Empty brackets are suppressed now for stored procedures
  in the FROM clause.
+ Field descriptions are loaded into metadata container from OLE DB Provider.
- Fixed bug with assertion failure when link condition contains sub query.
+ The User's Guide is updated.
+ More optimal grid filling is made when loading criteria and select list items.
= The "Move forward" and "Move backward" Union Sub-Query context menu items are
  renamed to the "Move left" and "Move right" for better understanding.
+ The "Safe for scripting" and "Safe for initialization" flags are set now.
+ The new properties are added to the IMetadataObject and IMetadataField 
  interfaces: ShortDescription and LongDescription.
+ The new properties are added to get information about objects in the metadata
  container from the Query Statistics: IStatsFromObject.MetadataObject,
  IStatsUsedColumn.MetadataObject, IStatsUsedColumn.MetadataField,
  IStatsOutputColumn.MetadataObject, IStatsOutputColumn.MetadataField.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder ActiveX Edition at the download page.

» Full Active Query Builder ActiveX Edition history