Product: Database Access
Type: new
Title: views in HSQLDB database can be edited
Posted by: [EMAIL PROTECTED]
Affected: -
Effective from: CWS dba24c
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [x]
*Description*
-------------
With the integration of CWS dba24c, you will be able to edit views in
embedded HSQL databases.
In the context menu of views (as well as in the Edit menu of the main
window, as usual), the entry "Edit" will be available, which opens the
same UI as used when creating a new view, or creating or editing
queries (vulgo: The Query Designer).
As a consequence, when you create a new view and save it, the query
designer will *not* automatically close itself after saving (which was
previously done since altering the view statement was not possible
anymore).
With this, views now behave more like queries than before.
One notable difference is that the UI information of the view design -
table window layout, column widths, and the like - are not preserved.
That is, after changing this UI layout, and saving and re-opening the
view design, the UI layout will be lost. This is due to the fact that
it cannot be stored (in opposite to the view's statement, naturally)
in the underlying database.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
