Specifications
CHAPTER 3 Managing the Database
Users Guide 89
3 Right-click on the Column property sheet and select Save Changes from
the pop-up menu.
Any changes you made in the property sheet are immediately saved to the
table definition.
Overriding definitions
In the Report painter and Form painter, you can override the extended attributes
specified in the Database painter for a particular report or form.
How the information is
stored
Extended attributes are stored in the InfoMaker system tables in the database.
InfoMaker uses the information to display, present, and validate data in the
Database painter and in reports and forms. When you create a view in the
Database painter, the extended attributes of the table columns used in the view
are used by default.
About display formats,
edit styles, and
validation rules
In the Database painter, you create display formats, edit styles, and validation
rules. Whatever you create is then available for use with columns in tables in
the database. You can see all the display formats, edit styles, and validation
rules defined for the database in the Extended Attributes view.
For more information about defining, maintaining, and using these extended
attributes, see Chapter 8, “Displaying and Validating Data.”
About headings and
labels
By default, InfoMaker uses the column names as labels and headings, replacing
any underscore characters with spaces and capitalizing each word in the name.
For example, the default heading for the column
Dept_name is Dept Name. To
define multiple-line headings, press Ctrl+Enter to begin a new line.
Validation Criteria that a value must pass to be accepted in a form. For
example, you can associate a validation rule with a Salary
column so that you can enter a value only within a
particular range.
The initial value for the column. You can select a value
from the drop-down list. The initial value must be the same
datatype as the column, must pass validation, and can be
NULL only if NULL is allowed for the column.
Edit Style How the column is presented in a report or form. For
example, you can display column values as radio buttons or
in a drop-down list.
Select this tab To modify these extended attributes