Difference between revisions of "Base/Features/Pool"
From Apache OpenOffice Wiki
< Base
Line 42: | Line 42: | ||
* support UPDATE/INSERT/DELETE in graphical view | * support UPDATE/INSERT/DELETE in graphical view | ||
* search and replace in SQL view | * search and replace in SQL view | ||
+ | | style="background-color:#c0c0ff; text-align:center; vertical-align:top" | designer | ||
+ | |- | ||
+ | | updatable queries based on other queries | ||
+ | | style="background-color:#c0ffc0; text-align:center; vertical-align:top" | user | ||
+ | |- align="left" style="background-color:#eeeeee" | ||
+ | | colspan="2" |''Forms'' | ||
+ | |- | ||
+ | | dialog-based forms | ||
+ | | style="background-color:#c0ffc0; text-align:center; vertical-align:top" | user | ||
+ | |- | ||
+ | | filter list box (more general: filter controls), i.e. a list box which filters the form it belongs to, depending on the user selection | ||
+ | | style="background-color:#c0ffc0; text-align:center; vertical-align:top" | user | ||
+ | |- | ||
+ | | charts in forms | ||
+ | | style="background-color:#c0ffc0; text-align:center; vertical-align:top" | user | ||
+ | |- | ||
+ | | easy possibility to open forms from within forms (without extensive macro knowledge) | ||
+ | | style="background-color:#c0ffc0; text-align:center; vertical-align:top" | user | ||
+ | |- | ||
+ | | templates for forms | ||
+ | | style="background-color:#c0c0ff; text-align:center; vertical-align:top" | designer | ||
+ | |- | ||
+ | | styles for form controls | ||
+ | | style="background-color:#c0c0ff; text-align:center; vertical-align:top" | designer | ||
+ | |- | ||
+ | | a "Button Wizard", which allows easy creation of button controls associated with certain common actions | ||
+ | | style="background-color:#c0c0ff; text-align:center; vertical-align:top" | designer | ||
+ | |- | ||
+ | | click-able fixed text controls ("Hyperlink Controls") | ||
+ | | style="background-color:#c0ffc0; text-align:center; vertical-align:top" | user | ||
+ | |- | ||
+ | | "Click Action Wizard", i.e. a wizard for inserting a button or hyperlink control, and associates a certain common action with this control | ||
+ | | style="background-color:#c0ffc0; text-align:center; vertical-align:top" | user | ||
+ | |- | ||
+ | | allow for "form based workflow", i.e. buttons in forms which open another form, where the second form has a button to return to the first form ... | ||
+ | | style="background-color:#c0ffc0; text-align:center; vertical-align:top" | user | ||
+ | |- | ||
+ | | more wizards for generatiung code snippets for common tasks | ||
+ | | style="background-color:#c0c0ff; text-align:center; vertical-align:top" | designer | ||
+ | |- | ||
+ | | direct creation of new macros/scripts from within the "Assign action" dialog | ||
+ | | style="background-color:#c0c0ff; text-align:center; vertical-align:top" | designer | ||
+ | |- | ||
+ | | fix some property names in property browser, for instance: | ||
+ | * "Print" => "Printable" | ||
+ | * fix the "Before Commencing" / "When Initiating" mess | ||
+ | | style="background-color:#c0c0ff; text-align:center; vertical-align:top" | designer | ||
+ | |- | ||
+ | | property browser | ||
+ | * "browse button" should be right-aligned with input controls in other lines | ||
+ | * separate some of the "General" properties into a "Appearance" tab | ||
+ | * have an "All" tab which displays all available properties at once | ||
| style="background-color:#c0c0ff; text-align:center; vertical-align:top" | designer | | style="background-color:#c0c0ff; text-align:center; vertical-align:top" | designer | ||
|} | |} |
Revision as of 13:38, 12 December 2008
The following is a wild collection of ideas for new features (or mere simple improvements) in Base. The order does imply nothing, in particular no priority ...
The "client" column in the below table is a very rough categorization whether the designer or the user of a database/application benefits from the feature. This separation of course does not always exist in reality, since end users tend to design their own database/application, too.
Ideas | Client |
Tables | |
allow printing a table structure | designer |
have a SQL preview in the table designer, reflecting the DDL necessary to create the current design of the table. This would be a live preview, and should also allow last-minute changes to the statement (before actually sending it to the server)
|
designer |
link tables from different sources (aka DBs) into one database. | user |
user interface for HSQL's text table feature (aka reading/writing CSV files) | user |
more intelligent deletion of table data (don't delete every single record, but the set of records described by the current filter in the table data view) | user |
HSQLDB: dBase support | user |
Queries | |
Query design improvements
|
designer |
updatable queries based on other queries | user |
Forms | |
dialog-based forms | user |
filter list box (more general: filter controls), i.e. a list box which filters the form it belongs to, depending on the user selection | user |
charts in forms | user |
easy possibility to open forms from within forms (without extensive macro knowledge) | user |
templates for forms | designer |
styles for form controls | designer |
a "Button Wizard", which allows easy creation of button controls associated with certain common actions | designer |
click-able fixed text controls ("Hyperlink Controls") | user |
"Click Action Wizard", i.e. a wizard for inserting a button or hyperlink control, and associates a certain common action with this control | user |
allow for "form based workflow", i.e. buttons in forms which open another form, where the second form has a button to return to the first form ... | user |
more wizards for generatiung code snippets for common tasks | designer |
direct creation of new macros/scripts from within the "Assign action" dialog | designer |
fix some property names in property browser, for instance:
|
designer |
property browser
|
designer |