Active Query Builder .NET Edition History

August 06, 2010

Active Query Builder .NET Edition v.1.13.3.232

+ The new property DisableCodeCompletion is added to SqlTextEditor and
  ExpressionEditor components.
+ MakeLowercase() and MakeUppercase() methods are added into SqlTextEditor.
  Corresponding hotkeys (Ctrl+U, Ctrl+L) and context menu items are implemented.
+ The new properties AddLinkedObjects and DeleteUnusedObjects are added to the
  QueryBuilder.LinkOptions group. They allow to use the component without query
  building area. Fields should be dragged from the database objects tree 
  directly to the columns grid in this mode. The AddLinkedObjects instructs the 
  component to add necessary objects to join the newly added object with
  existing objects. For example, using the Northwind database, by adding Orders
  and Products tables to the query, the [Order Details] table will be added 
  automatically and joins will be set according to the foreign keys. 
  The DeleteUnusedObjects property instructs the component to remove objects
  from the query if their fields are not used in the query and these objects are
  no longer used to link other objects.
  These properties are not usable now since the query building area can not be
  hidden now and the fields are not shown in the tree. These features will be
  added in the new minor version.

July 14, 2010

Active Query Builder .NET Edition v.1.13.2.230

- Bug with "No Metadata Provider" exception in Metadata Editor when exporting
  metadata to XML file is fixed.
+ Metadate Editor displays a progress bar during the fields loading now.
= IEnumerable interface is implemented for the MetadataContainer object now.
+ Ability to connect already loaded DevExpressControlFactory.dll
  to the query builder is made (e.g. when you using tools like ILMerge to
  assemble your application into a single executable file). 

See the full story for details

July 08, 2010

Active Query Builder .NET Edition v.1.13.1.228

- DB2: Loading of complex queries with CTE is fixed.
- VistaDB: Unsupported features are removed from the syntax provider.
- Minor issues with SqlTextEditor on a DevExpress form with a complex layout
  controls combination are resolved.
= Numerous improvements and bug fixes in Metadata Editor are made.
- Expression Editor: Exception when trying to insert a function using the
  context menu is fixed.
- Expression Editor: Items in the function list were duplicated sometimes.
+ Oracle: Global pipelined functions can be used in FROM clause and loaded in 
  the metadata tree now.

June 22, 2010

Active Query Builder .NET Edition v.1.13.0.221

+ Professional version of the component suite is released.
+ The new ExpressionEditor component available in the Professional version only.
+ Completely re-made Metadata Editor is available now (in all versions).
= DevExpress dependencies of ActiveDatabaseSoftware.DevExpressControlFactory.dll
  are updated to v.10.1.4.0.
= OracleNativeMetadataProvider: Oracle.DataAccess.dll reference is updated to
  the latest version (v.2.111.7.20).

May 06, 2010

Active Query Builder .NET Edition v.1.12.5.220

= The Full-Featured MDI Demo is improved. The "Build" button is added to the
  OLE DB connection settings dialog to show Data Link Properties dialog to help
  users to build OLE DB connection string.
= Adding component icons into the Visual Studio 2010 toolbox is supported by the
  installer now.
- Installer was not able to add component icons into the Visual Studio toolbox 
  if C# language is not installed. Fixed now.

April 08, 2010

Active Query Builder .NET Edition v.1.12.4.219

= The Connection property of IDbConnection type is added to the
  BaseMetadataProvider. It allows to get the connection object from the
  QueryBuilder.MetadataProvider without casting to specific metadata provider
  and connection types.
= DevExpress dependencies of ActiveDatabaseSoftware.DevExpressControlFactory.dll
  are updated to v9.3.4.0.
- Assertion error if using an alias the same as the object name ("SELECT * FROM
  Orders Orders") is fixed.
- Fields with same names but from different tables were identified incorrectly
  in some cases. Fixed now.

March 26, 2010

Active Query Builder .NET Edition v.1.12.3.218

- The bug in WITH clause field list is fixed.
- MySQL: CONVERT function support is improved.
- PostgreSQL: metadata filter is fixed.

March 23, 2010

Active Query Builder .NET Edition v.1.12.3.217

+ The new context menu item "Add Common Table Expression" is added to the query
  building area.
- MS Access: NULL is removed from list of valid identifiers.
- Fixed wrong naming for query objects like "table.*" if more than one "table"
  used in the query.
- Query builder was crashing when user moved the splitter during the query
  update. Fixed now.

March 16, 2010

Active Query Builder .NET Edition v.1.12.2.216

+ The new source code example "LoadMetadataAsync" is added to demonstrate
  asynchronous loading of metadata.
- Hotfix: DataSourceControl was not painted last item. 

March 09, 2010

Active Query Builder .NET Edition v.1.12.1.215

+ French translation is added.
- Flickering of data source controls during the resizing is reduced.
- Weird exception "Used metadata provider cannot automatically load metadata"
  of OracleMetadataProvider is fixed.
= The Full-featured MDI Demo is improved. New buttons are added to the toolbar
  to fire specific context menu actions of the component (add object, derived
  table, show query properties, add new and copy the current union sub-query).