Downloads

Active Query Builder Java Edition History

May 12, 2010

Active Query Builder Java Edition v.1.2.8.1029

+ FairCom C-Tree SQL server is supported now. Use it with the SQL92SyntaxProvider 
  or the UniversalSyntaxProvider.
- MS Access table fields fetching is fixed.

April 27, 2010

Active Query Builder Java Edition v.1.2.7.1028

- 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.
- Option that hides global asterisk item "*" does not hide "Table.*" items. 
  Fixed now.

March 26, 2010

Active Query Builder Java Edition v.1.2.6.1027

+ The new context menu item "Add Common Table Expression" is added to the query
  building area.
- Oracle: Server cursor leaks are eliminated.
- 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.
- MySQL: CONVERT function support is improved.
- PostgreSQL: Metadata filter is fixed.
- MetadataContainer.saveToXMLFile() did not close the file. Fixed now.

March 17, 2010

Active Query Builder Java Edition v.1.2.5.1025

+ French translation is added.
+ The new source code example "LoadMetadataAsync" is added to demonstrate
  asynchronous loading of metadata.
+ MSSQLCESyntaxProvider is implemented to support Microsoft SQL Server Compact
  Edition.
- MS Access: The bug with unsupported FULL OUTER JOIN is fixed.

January 11, 2010

Active Query Builder Java Edition v.1.2.4.1024

+ The new properties are added to the QueryBase class to set up the Union
  operator programmatically:
  - get/setUnionOperator(): gets/sets the unifying operator ('Union', 'Except',
    'Intersect' etc.);
  - is/setUnionAllFlag(): gets/sets the 'All' keyword for the operator;
  - get/setUnionOperatorFull(): gets/sets the full operator string (e.g. 'Union
    All').
+ The new get/setDiagramPaneVisible() property is made to show hide the diagram
  pane.
- The AfterPropertiesDialog event was firing even if the dialog has been
  canceled. Fixed now.

November 24, 2009

Active Query Builder Java Edition v.1.2.3.1023

+ MS SQL: support for old-style TransactSQL outer joins: "*=" and "*=" operators.
  (only if ServerVersion < MSSQL2005)
+ Sybase: support for old-style TransactSQL outer joins: "*=" and "*=" operators.
+ MS SQL: Constants for SQL Server 2008 are added.

November 17, 2009

Active Query Builder Java Edition v.1.2.2.1022

= Active Query Builder automatically generates aliases for virtual calculated
  fields if they have no alias defined.
- Firebird: Support of predefined context variables (CURRENT_DATE, CURRENT_TIME,
  CURRENT_TIMESTAMP) is added.

November 12, 2009

Active Query Builder Java Edition v.1.2.2.1021

+ The new property is/setLoadJoinsFromWhereClause() is added to instruct the
  Query Builder to not treat expressions like "tbl1.FieldName = tbl2.FieldName"
  as joins. They will be loaded as generic WHERE clause expressions instead.
+ The new method getSchemaNames() to retrieve list of database schemas is added 
  to syntax providers.
- 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.
- DB2: Metadata filtering is fixed.
- DiagramObjectDeleting event was not fired when closing a diagram object
  through its context menu. Fixed now.

October 30, 2009

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

Active Query Builder Java Edition 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.