- September 17, 2010
-
Active Query Builder History v.1.13.10.241
+ New visual feature preview: Set the FieldListOptions.ShowCollapseExpandButton
property to true to show the new button that collapses and expands the field
list.
- September 16, 2010
-
Active Query Builder History v.1.13.9.240
- Metadata Editor: Fixed error when metadata loaded from XML without having
a Syntax Provider selected.
- Metadata Editor: It was impossible to delete a foreign key. Fixed now.
- September 15, 2010
-
Active Query Builder History v.1.2.13.1040
+ get/setCustomDiagramPaneDropTarget() and get/setCustomCriteriaListDropTarget()
methods are added to the QueryBuilder. Use them to set custom DropTarget
objects for the Diagram Pane and Criteria List controls and override default
drag and drop behaviour.
Since DropTarget object can be bound to a single component only, you should
pass different instances of your DropTarget implementations to those methods.
- Fixed bug with "$" sign in Access syntax.
- September 15, 2010
-
Active Query Builder History v.1.13.9.239
- Fixed bug with the "$" sign in Access syntax.
- Metadata Editor: fixed bug with the tree label editing.
- Metadata Editor: fixed bug with the foreign keys editing.
- September 07, 2010
-
Active Query Builder History v.1.2.12.1038
+ Added support for Ingres database server. Use it with UniversalSyntaxProvider.
= Default "SELECT * FROM" statement is removed.
+ QueryBuilder.CriteriaListOptions.setCriteriaListHeaderFont() method is added.
- September 02, 2010
-
Active Query Builder History v.0.2.2
= Overall performance improvement in Internet Explorer is made.
= Expression and Sorting drop-down controls are improved.
- Fixed changing of the grid columns width on selecting a column for some
browsers.
- Small CSS fixes for Internet Explorer 7 are made.
- August 16, 2010
-
Active Query Builder History v.0.2.1
+ The canvas can be hidden now. Use the "visible" property on
control or just delete it from the web page. The new sample project
"no_design_area_demo" is added. In conjunction with the new properties of the
QueryBuilder component this allows you to build queries by dragging fields
from the database objects tree to the columns grid.
+ The new properties AddLinkedObjects and DeleteUnusedObjects are added to the
QueryBuilder.LinkOptions group. The AddLinkedObjects instructs the
component to add 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.
- Fixed bug with clearing a query text or removal of all tables from the canvas.
+ Compatibility with Microsoft Ajax Framework is made. Now the component can be
used with UpdatePanel.
- Fixed bug with link rendering and creation.
- Ability to change join types via the context menu is restored.
+ The jQuery library is upgraded from 1.7.2 to 1.8.3.
- August 06, 2010
-
Active Query Builder History v.1.13.3.232
+ The new property DisableCodeCompletion is added to SqlTextEditor and
ExpressionEditor components.
+ MakeLowercase() and MakeUppercase() methods are added into SqlTextEditor.
Corresponding hotkeys (Ctrl+U, Ctrl+L) and context menu items are implemented.
+ The new properties AddLinkedObjects and DeleteUnusedObjects are added to the
QueryBuilder.LinkOptions group. They allow to use the component without query
building area. Fields should be dragged from the database objects tree
directly to the columns grid in this mode. The AddLinkedObjects instructs the
component to add 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.
These properties are not usable now since the query building area can not be
hidden now and the fields are not shown in the tree. These features will be
added in the new minor version.
- July 23, 2010
-
Active Query Builder History v.0.2.0
- Fixed various problems while working in Internet Explorer 7: database objects
tree layout is corrected, links creation is possible now.
- Installer is adding component to the toolbox now.
- Other minor bugs are fixed.
- July 21, 2010
-
Active Query Builder History v.1.2.9.1033
+ Signed version of ActiveQueryBuilder.jar is added. Use it with applets
to avoid security warnings and restrictions.
= ActiveQueryBuilder.jar now contains no classes in the default package.
- Query Builder was unable to load table fields from MSSQL because it supports
the cursor holdability on the connection level only. Fixed now.