Downloads

Active Query Builder Java Edition History

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.

October 08, 2009

Active Query Builder Java Edition v.1.1.3.1018

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