Downloads

Active Query Builder WinForms Edition History

October 29, 2009

Active Query Builder WinForms Edition v.1.11.2.200

+ 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.1.11.1.199

+ 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. 9.2.6.0.
= MySQL ADO.NET provider dependencies are updated to v. 6.1.2.0.

October 21, 2009

Active Query Builder WinForms Edition v.1.11.0.198

+ The new properties are made to control case sensitivity of metadata filter
  items: MetadataFilterItem.SchemaMaskCaseSensitive and
  MetadataFilterItem.ObjectMaskCaseSensitive.
+ 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.1.10.5.197

+ 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.1.10.4.195

- Minor localization fixes are made.

October 07, 2009

Active Query Builder WinForms Edition v.1.10.4.194

+ Portuguese (Brazil) translation is added.
+ Oracle: Retrieval of descriptions for objects and fields from the database is
  implemented.
+ 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.1.10.3.192

- 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.1.10.2.191

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

September 14, 2009

Active Query Builder WinForms Edition v.1.10.2.190

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

September 11, 2009

Active Query Builder WinForms Edition v.1.10.2.189

+ 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
  MetadataQualifiedNameList.
- The CROSS JOIN processing bug is fixed.
- Wrong link context menu coordinates when the diagram pane is scrolled down
  are fixed.