Downloads

Active Query Builder Java Edition History

November 25, 2011

Active Query Builder Java Edition v.1.5.0.1100

+ The new row controlling toolbar is added to the leftmost column of 
  CriteriaListControl. You can control visibility of this column and it's state 
  by using the is/setRowControllerVisible() and is/setRowControllerExpanded() 
  properties.
+ The check box is added to the Grouping column header. It allows to toggle 
  the grouping for all criteria items at once.
+ The new get/setCreateWhereJoinsByDefault() property is added to all syntax 
  providers. The newly created link conditions will be added to the WHERE clause
  instead of creating of joins in the FROM clause.
+ The new SQLBuilder.BeginBuildSQLForNode, SQLBuilder.EndBuildSQLForNode, 
  BaseSQLBuilder.BeginBuildSQLForNode, BaseSQLBuilder.EndBuildSQLForNode events 
  are added to perform additional processing on building the SQL query text.
+ The new properties are added to LinkOptions property group: 
  get/setAddLinkedObjects(), get/setDeleteUnusedObjects(). The first property 
  instructs the component to add the necessary objects to join the newly added
  object with existing objects. For example, using the Northwind database, 
  by adding Orders and Products tables to the query, the [Order Details] table 
  will be added automatically and joins will be set according to the foreign 
  keys. The DeleteUnusedObjects property instructs the component to remove 
  objects from the query if their fields are not used in the query and these 
  objects are no longer used to link other objects.
+ The new is/setCreateLinksByIdenticalFieldNames() property is added. It may be
  helpful for the databases that does not foreig keys, but suppose to link
  objects in the query by identical field names.
+ The new UnionSubQuery.addLinksFromExpression() method is added.
+ The new methods are added to help iterating through sub-queries in the query:
  QueryBuilder.getSubQueryList(), QueryBuilder.getUnionSubQueryList(), 
  UnionGroup.getUnionSubQueryList().
+ The new GetProcedureParameters event is added to let provide procedure 
  parameter values without showing of the embedded dialog.
= SQLite: Loading of fields and foreign keys is made using PRAGMA queries.
= Formatting options for CTE sub-queries are added via the
  PlainTextSQLBuilder.get/setCTESubQueryFormat() property.
= LinkCreating and LinkCreated events will be also fired for links being 
  created automatically from foreign keys now.
= Default value of "Criteria for" for non-aggregated query columns is changed
  "For groups" (HAVING) to "For values" (WHERE).
- PostgreSQL: undocumented SUBSTRING function syntax "SUBSTRING('a','b','c')" 
  will being automatically converted to "SUBSTRING('a' FROM 'b' FOR 'c') during
  the parsing.
- Oracle: The bugs with "ORDER SIBLINGS BY" clause and "TRANSLATE" function 
  are fixed.
- Oracle: The bug when removing references to datasources from "CONNECT BY"
  clause. is fixed.
- MSSQL: The bug with "OPENQUERY" function is fixed.
= MSSQL: Definition of the "FOR XML" clause is updated according to the latest
  server version.
- MySQL: The missing built-in functions are added: COALESCE, GREATEST, LEAST 
  and INTERVAL.
- SQLite: Fixed list of aggregate and built-in functions.
- PostgreSQL: Parsing of logical expressions from criteria cells is fixed.
- Firebird: The "INT" alias is added for INTEGER type.
- Column aliases generation in ORDER BY is fixed.
- Metadata object names hash was not rebuilt after MetadataContainer assignment.
  Fixed now.
- The UnionSubQuery.setSQL() method did not remove the previous union sub-query 
  content. Fixed now.
- The QueryBuilder.clear() method is fixed.
- The bug with generating invalid SQL when object and database names are equal
  is fixed.
- The bug with adding derived table of CTE into the same CTE is fixed.
- The bug when "ORDER BY" is added to a query with miltiple UNIONs is fixed.
- A link might be attached to wrong datasource on the design pane in some rare 
  conditions. Fixed now.
= Spanish translation is updated.
= Performance optimizations are made, memory leaks are eliminated.
= Other minor bugfixes are made.

October 19, 2011

Active Query Builder Java Edition v.1.4.5.1083

+ DB2 Syntax Provider: The new get/setNamingConvention() property is added to
  affect the object name separator (slash or dot).

August 26, 2011

Active Query Builder Java Edition v.1.4.4.1082

- MySQL: Foreign key relationships were inverted. Fixed now.
- PostgreSQL: Fixed parsing of SUBSTRING function and ARRAY literals.
+ The new refreshDatasourcesMetadata() method is added. Use it to update
  bindings between query and metadata objects. Might be useful if you modified 
  or reloaded metadata while a query is loaded in the query builder.

July 28, 2011

Active Query Builder Java Edition v.1.4.3.1081

- The setLayoutSQL() method did not restore the query layout. Fixed now.

July 26, 2011

Active Query Builder Java Edition v.1.4.3.1080

- Union navigation bar buttons were flickering on some union queries. Fixed now.

July 21, 2011

Active Query Builder Java Edition v.1.4.3.1079

- Query builder did not restore selection state of the asterisk (*) field list
  item on parsing the "SELECT tablename.* ..." SQL statements. Fixed now.

July 18, 2011

Active Query Builder Java Edition v.1.4.3.1078

+ The new methods are added to UnionSubQuery: Clear(), getSQL(), setSQL().
+ The new UnionSubQuery.ConvertDatasourceToDerivedTable() method is added.
- The problem when diagram object could be moved off-pane is fixed.
- MS SQL Server: Loading of metadata objects from linkes servers is fixed.

June 29, 2011

Active Query Builder Java Edition v.1.4.2.1077

- MS SQL Server: Metadata loading query is fixed.
+ Internal debug tool is made. It may provide additional information on 
  assertion or unhandled exception. The tool will output the debug information
  into System.err stream. Turn it on using a line of code in the main() method
  of your main class: "com.adbs.utils.Helpers.collectDebugInfo = true;"  

June 21, 2011

Active Query Builder Java Edition v.1.4.1.1076

- Oracle: Parsing of "precision", "nulls", "time", "read", "interval" 
  identifiers is fixed.
- Another exception in non-visual mode is fixed.

June 20, 2011

Active Query Builder Java Edition v.1.4.1.1075

= Speed optimizations are made.
- Fixed exception with accessing various options in non-visual mode.