Active Query Builder WinForms Edition History

October 29, 2009

Active Query Builder WinForms Edition v.

+ New feature: Virtual database objects and fields. It allows to hide complex
  expressions and sub-queries back of ordinary fields and save derived tables as
  ordinary database objects. See "VirtualObjectsAndFields" source code example
  for demonstration and details.
+ 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.

October 26, 2009

Active Query Builder WinForms Edition v.

+ Source code of the DevExpressControlFactory is added to appropriate installation
  package. Now you can rebuild it with any DevExpress controls version you have.
= DevExpress controls dependencies are updated to v.
= MySQL ADO.NET provider dependencies are updated to v.

October 21, 2009

Active Query Builder WinForms Edition v.

+ The new properties are made to control case sensitivity of metadata filter
  items: MetadataFilterItem.SchemaMaskCaseSensitive and
+ The new property is added to create aliases automatically based on alternate
  names: SelectListOptions.CreateColumnAliasesFromAltNames.
= Loading of XML metadata files created with different Active Query Builder
  editions (Delphi/ActiveX and Java) is improved. 

October 19, 2009

Active Query Builder WinForms Edition v.

+ New VistaDB4MetadataProvider is added to support VistaDB 4.0.
= VistaDBSyntaxProvider is improved.
= DataSourceControl.DataSource property is made public.

October 09, 2009

Active Query Builder WinForms Edition v.

- Minor localization fixes are made.

October 07, 2009

Active Query Builder WinForms Edition v.

+ Portuguese (Brazil) translation is added.
+ Oracle: Retrieval of descriptions for objects and fields from the database is
+ SQLite: The query properties form is implemented.
+ SQLite: Ability to fetch metadata from "attached" databases is added.
+ New helper methods are added to the BaseSQLContext object for splitting full
  object names by parts: ExtractNameFromFullName(),
  ExtractSchemaFromFullName(), ExtractDatabaseFromFullName().
+ Bunch of helpers are added to the MetadataContainer to add objects by theirs
  full or partially qualified name: AddObject(), AddTable(), AddView(), 
  AddProcedure(), AddSynonym().
= The LIKE criteria parsing is improved. Manually entered criteria like "LIKE
  John Doe" will be distinguished as "LIKE 'John Doe'".
- SQLite: LIMIT support in the main query is fixed.
- SQL dialects without multiple database support (like Oracle) didn't skip 
  default schema from object names. Fixed now.
- Oracle: Parsing of the SEED keyword is fixed.

September 22, 2009

Active Query Builder WinForms Edition v.

- MSSQL: Parsing of DatePart and DateName functions is fixed.
- Oracle: Parsing of "CONNECT BY" and "START WITH" clauses sequence is fixed.
- Minor bugfix in metadata filtering is made.

September 15, 2009

Active Query Builder WinForms Edition v.

- The bug with duplicating mixed case field names from case sensitive servers 
  is fixed.

September 14, 2009

Active Query Builder WinForms Edition v.

- MSSQL: Fixed parsing of fields with names matching datatype names, 
  like "DateTime".

September 11, 2009

Active Query Builder WinForms Edition v.

+ New properties in the QueryBuilder and PlainTextSQLBuilder components:
  AsKeywordInExpressionAlias and AsKeywordInObjectAlias. You can use them to
  force the query builder to always show or omit AS keyword before aliases.
+ The new events DatasourceFieldRemoving, DatasourceFieldRemoved are added to
  control removal of fields by unchecking them from the datasource field list.
+ Basic support for custom aggregate functions is implemented.
+ MSSQL: Custom aggregate functions retrieval is made.
+ Oracle, PostgreSQL: Interval literals are supported now.
+ The INNER keyword can be omitted now in join specifications for Firebird and
  MSSQL via the InnerKeywordInLinks property.
= (!) API changes: MetadataFieldNameList class is renamed to
- The CROSS JOIN processing bug is fixed.
- Wrong link context menu coordinates when the diagram pane is scrolled down
  are fixed.

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