Each record type has a Fields grid, which shows its associated
fields. You can use this grid to add fields to the record type and to modify
field properties.
Before you begin
When naming fields, do not use keywords
that are reserved by the database vendor. See your vendor documentation
for a list of reserved keywords.
About this task
The DB
Column Name is the name that the Designer uses for the table column.
By default it is the same as the field name.
To add a
field to a record type:
Procedure
- Start the Designer.
- In the Workspace, expand the Record Types folder,
expand the record type, and double-click Fields.
- Click .
- In the New Field window, type a field name.
- In the Type field, select
a field data type.
- Select the Visible in queries check
box to ensure that this field is included in queries run from the Rational® ClearQuest® Client. If you do not
want to include this field in queries, clear this check box.
What to do next
To make the new field available to users:
- You must associate it with a form control. For more information,
see Working with form controls.
- You must check in the schema and apply that version of it
to the user database.
After you check in the schema, you cannot change the type, size, or
DB Name properties of the field. However, you can change the name that you
use to refer to the field.