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.
allow printing a table structure
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)
link tables from different sources (aka DBs) into one database.
user interface for HSQL's text table feature (aka reading/writing CSV files)
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)
HSQLDB: dBase support
Query design improvements
better support for functions: all supported and known functions should be listed in the respective field, so that e.g. HOUR(
function auto pilot
sub selects: should be little table windows, like queries and tables already are
query navigator, displaying the hierarchical structure of a query
live preview of the statement even in the graphical view
consolidate query design and the "Execute SQL" dialog:
(persistent!) history of executed statements
execute all kind of statements, not only SELECTs
load .sql files containing SQL scripts to execute
support UPDATE/INSERT/DELETE in graphical view
search and replace in SQL view
updatable queries based on other queries
filter list box (more general: filter controls), i.e. a list box which filters the form it belongs to, depending on the user selection
charts in forms
easy possibility to open forms from within forms (without extensive macro knowledge)
templates for forms
styles for form controls
a "Button Wizard", which allows easy creation of button controls associated with certain common actions
click-able fixed text controls ("Hyperlink Controls")
"Click Action Wizard", i.e. a wizard for inserting a button or hyperlink control, and associates a certain common action with this control
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 ...
more wizards for generatiung code snippets for common tasks
direct creation of new macros/scripts from within the "Assign action" dialog
fix some property names in property browser, for instance:
"Print" => "Printable"
fix the "Before Commencing" / "When Initiating" mess
"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