4D v13.4Structure editor |
||
|
4D v13.4
Structure editor
Structure editor
You can access the Structure editor by choosing the Database Structure command in the Design menu or by clicking on the button in the 4D toolbar. You use the Structure editor to manage the database structure — the tables and their relations. It gives you control over such things as tables, table properties, fields, field properties, and table relations. The Structure editor provides a graphic view of a database’s structure as well as a toolbar and context menus that you can use to carry out database design operations. Each table is represented by a table image in the Structure editor. It shows the fields and their types, in the form of icons. An information bar displays the characteristics of tables and fields as the mouse moves over them. A floating Inspector palette can be used to view and modify the properties of structure objects and of the structure editor itself. This window is described in the Inspector palette section. The structure editor has a toolbar containing functions like the addition of objects, as well as navigation and display options: The lower part of the editor window is an information bar displaying data corresponding to the area the mouse is moving over: table, field or relation. To work with the image of an object in the Structure editor, you will first need to select it. You can then specify its properties, move it, resize it, delete it, etc. It is also possible to select several objects of the same type simultaneously in order, for example, to display or modify their common properties in the Inspector palette. You can even select fields from different tables. To select a table:
To select a field or relation:
To select several objects of the same type (tables, fields, relations):
You can resize or move the table images in the Structure editor according to your requirements. When you add fields to a table or when you reduce the size of a table, there may be more fields in the table than the image can display. When this happens, 4D automatically adds a cursor than you can use to scroll through the list of visible fields: You can resize the table image in order, for example, to display more field names or to reorganize your screen. There are several possibilities available:
Notes:
4D Server: If you resize a table image using 4D Server, the table is resized for all the users in the Design environment. You can move table images in order to regroup them according to function or to reorganize the Structure editor window. You can also align them to improve the readability of the structure. Any relations are redrawn to correspond with the new locations. To move a table image manually:
4D Server: If you move a table image when using 4D Server, the table appears in its new location for all users in the Design environment. To align two or more tables:
Specific scrolling functions facilitate navigation among large structures:
You can modify the display scale of the database structure using the Zoom menu in the structure toolbar. 100% is the default value on opening of a database. Zoom action is focused on the selection if there is one. The current zoom setting is specific to each user. It is memorized when the window is closed. Note: An option in the Preferences can be used to configure the graphic rendering of the Structure editor during a zoom. For more information, refer to Structure Page . The Display button in the toolbar of the Structure editor is associated with a menu and lets you choose the objects to be displayed in the structure according to their type: By default, all objects are displayed. This feature allows various representations or views — from the simplest to the most complete — and provides an analysis tool for the structure based on the level of information required. The choices are applied to all the tables and fields. They are saved per user and memorized when the window is closed. Hiding certain objects does not change the position of the tables.
You can hide groups of tables in the Structure editor based on folders that are defined in the Explorer window on the Home Page. You configure the display of the tables using the Folders button in the toolbar of the Structure editor. The menu associated with the button displays the commands that manage the display as well as the list of folders specified in the database. A check will appear next to each folder displayed. You can modify the current display by selecting or deselecting a folder using this menu.
Note: You can set the appearance of dimmed tables (by folder) in the Structure editor to either Dimmed or Invisible using an option found on the Structure Page of the Preferences. It is necessary to close and reopen the Structure editor window in order for this preference to be taken into account. The Structure editor window has specific properties that can be set using the Inspector. To display the properties of the Structure editor window, you can either:
The Inspector palette displays the Structure properties: The following properties can be set:
4D lets you carry out searches in the Structure editor window. Searches can be among the following elements:
To do a search, enter the character string or table number to be searched for in the Find in Structure area of the Structure editor. Entering a value in this area displays an options bar below it that can be used to specify the scope and type of search desired:
Searches are carried out in real time, as you enter the values. Tables and/or fields found by the search are “lit up.” |
PROPERTIES
Product: 4D |