The SCHEMA_NAME might be PUBLIC only for ease, or perhaps a user input in design mode. It would need to support the following syntax: DB_FILENAME.SCHEMA_NAME.TableName where DB_FILENAME is determined by the Switchboard at runtime, such as:. With H2, I think the incompatibility is a lack of schema support with the Switchboard's DBNAME variable. I'm having the same problem with Base-H2. NOTE:Icons used in samples and Extension Menu entry are owned by This feature makes it possible to have a main switchboard that gives access to forms and reports from any number of databases. A Switchboard Link is an entry that links to another Switchboard menu-but does not have entries this is usefully to get back to another menu (such as main menu) from an entry that may be nested somewhere down the hierarchy.Ī Database form or report need not be located in the database where the Switchboard is located. A Switchboard is an entry that appears as the parent of other entries (a menu). At runtime, the difference between a Switchboard and Switchboard Link is trivial. The Form and Report entries open a form or report, respectively. Forms, Reports, Switchboards, and Switchboard Links. The extension can only be opened from a Registered Base document.Ĭurrently, there are four types of menu entries that can be generated. The main hook can be accessed through the Tools | Add-ons | Base Switchboard menu option. This form document can be modified by the user-keeping in mind that the menu entries need to be positioned at runtime.Īll these items are generated automatically when the extension main hook is launched, and that database document does not have said objects. This is a blank form generated by the wizard, and is populated with the menu entries. The generators creates three database objects.ġ)The SWITCHBOARD table which has some basic information about the switchboard such as size and location of main form as well as size and positioning of menu entries.Ģ)The SWITCHBOARDITEMS table which has the menu entries configuration information.ģ)The SWITCHBOARD form.

Furthermore, you can specify the size and screen location of the form to be opened. The switchboard can be grouped into categories, each of which can contain any number of menu entries.

The Switchboard extension generates a Switchboard/Main Menu interface to access Base forms and reports.

A table as a field in openoffice base