The Create a Record Attribute Frame
To specify a record attribute, use the Create a Record Attribute frame. Display this frame from the Edit a Record Attribute frame by selecting the Create menu operation. The Create a Record Attribute frame is shown in the following figure:
ABF does not allow a record type to contain an attribute of the same record type as itself, nor can its attributes be records that include an attribute of the parent type. For example, if record type A includes an attribute of type C, C cannot contain an attribute of record type A.
The scope of a record attribute is the record itself. No two attributes for a record can have the same name; however, attributes in different records can have the same name. An attribute type can be:
• Any Ingres data type.
• Any other record type defined for the application.
• An array of any other record type.
This frame has the following fields:
Name
(Required) Specifies the name of the record attribute
Short Remark
(Optional) Provides a brief description
Type
(Required) Specifies the name of any record attribute defined for this application or any Ingres type. The data type you enter here determines whether you fill in the Nullable or the Array field next.
• If you enter an Ingres data type, you see the Nullable field.
• If you enter the name of a record type created for the application, you see the Array field.
Nullable
Indicates whether the record attribute is nullable. Only attributes of an Ingres type can also be nullable. Record types cannot be nullable. The default depends on the application query language: "yes" for SQL and "no" for QUEL.
Array
Indicates whether this attribute is a single record or a dynamic array of records. Arrays cannot be composed of Ingres data types.
The following menu operations are available for this pop-up frame:
OK
Creates the record attribute
Cancel
Cancels creation of the record attribute
ListChoices
Displays a list of legal values for the field from which you can choose or field data specifications
Help
Accesses the Help utility
