Active Query Builder Java Edition History

March 26, 2010

Active Query Builder Java Edition v.

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

+ 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
- MS Access: The bug with unsupported FULL OUTER JOIN is fixed.

January 11, 2010

Active Query Builder Java Edition v.

+ 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
+ The new get/setDiagramPaneVisible() property is made to show hide the diagram
- The AfterPropertiesDialog event was firing even if the dialog has been
  canceled. Fixed now.

November 24, 2009

Active Query Builder Java Edition v.

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

= 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,

November 12, 2009

Active Query Builder Java Edition v.

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

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

+ The new properties are made to control case sensitivity of metadata filter
  items: MetadataFilterItem.get/setSchemaMaskCaseSensitive() and
+ 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.

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

Active Query Builder Java Edition v.

- Oracle: Parsing of the SEED keyword is 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