Downloads

Active Query Builder History History

November 10, 2009

Active Query Builder History v.1.11.4.203

- LayoutSQL now saves SQL without virtual objects expansion.
- Virtual objects can have empty aliases. If alias is empty, AQB creates one from
  the virtual object name.
- Metadata relations loading from Sybase ASE is fixed.

November 05, 2009

Active Query Builder History v.1.11.3.201

+ New FieldListDescriptionColumnOptions.UseLongDescription property is added to
  control which description will be shown in the Description column of field 
  lists: if false (default), the MetadataField.ShortDescription is displayed;
  if true, the MetadataField.LongDescription is displayed.
+ New property LoadJoinsFromWhereClause is added. Using this property you can
  instruct the Query Builder to not treat WHERE conditions like "tbl1.FieldName
  = tbl2.FieldName" as joins. They will be loaded in the Columns pane instead.
+ Method GetSchemaNames() retrieving list of database schemas is added to
  syntax providers.
- DB2: Metadata filtering is fixed.
- Memory leak is fixed.

October 30, 2009

Active Query Builder History v.1.2.1.1020

+ 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 29, 2009

Active Query Builder History 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 History 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 History 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 21, 2009

Active Query Builder History v.1.2.0.1019

+ The new properties are made to control case sensitivity of metadata filter
  items: MetadataFilterItem.get/setSchemaMaskCaseSensitive() and
  MetadataFilterItem.get/setObjectMaskCaseSensitive().
+ The new property is added to create aliases automatically based on alternate
  names: SelectListOptions.get/setCreateColumnAliasesFromAltNames().
= Loading of XML metadata files created with different Query Builder editions
  (Delphi/ActiveX and .NET) is improved. For correct data types interpretation
  the files must be saved with latest versions of the component.
- Generation of versioning information in MANIFEST.MF inside of JAR file is
  fixed. This is workaround for known NetBeans issue #166895.

October 19, 2009

Active Query Builder History v.1.10.5.197

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

October 16, 2009

Active Query Builder History v.1.13.21.0

+ The new methods are added to get database schemes list: 
  TacBaseSyntaxProvider.GetSchemaNames - for specific database servers;
  TacBaseMetadataProvider.GetSchemaNames - for generic ADO connections.
+ Unambiguous reading metadata from XML generated by other AQB Editions 
  (.Net, Java) is made.
+ The new TacFieldsListDescriptionColumnOptions.ShowLongDescription property 
  is added to control which description will be shown in the Description column
  of the fields list:  
    when it's False (default), the TacMetadataField.ShortDescription is shown;
    when it's True, the TacMetadataField.LongDescription is shown.

October 16, 2009

Active Query Builder History v.1.13.21.0

+ Unambiguous reading metadata from XML generated by other AQB Editions 
  (.Net, Java) is made.
+ The new IFieldsListDescriptionColumnOptions.ShowLongDescription property 
  is added to control which description will be shown in the Description column
  of the fields list:  
    when it's False (default), the IMetadataField.ShortDescription is shown;
    when it's True, the IMetadataField.LongDescription is shown.