
Step 2: Set field types and formats.
In this step you give the fields their properties. When you click a field,
the information on the right changes. (See Figure 185.) You can then
make changes to meet your needs. Click each field, one at a time, and
make the changes listed below.
Figure 185: Changing field types
Note
If any of these fields requires an entry, set Entry required to Yes.
An entry with that field blank will then not be allowed. In
general, only set Entry required to Yes if something must always
be put in that field. By default, Entry required is set to No.
• CollectionID: Change AutoValue from No to Yes.
• AlbumTitle:
– Entry required: Leave Entry required as No, unless all of your
music is in albums.
– Length: Unless you have an album title that exceeds 100
characters counting the spaces, do not change the length.
Note
In Base the maximum length of each field must be specified on
creation. It is not easy to change this later, so if in doubt specify
a greater length. Base uses VCHAR as the field format for text
fields. This format only uses the actual number of characters in a
field up to the limit set. So, a field containing 20 characters will
only use space for 20 characters even if the limit is set at 100.
Two album titles containing 25 and 32 characters respectively
will use space for 25 and 32 characters and not 100 characters.
• Artist: Use the Default setting. And since music has artists, set
Entry Required to Yes.
• Date Purchased: Field type: default date setting. Entry required
should be No. (You may not know the date.)
• Format: Only change the Entry Required setting: from No to Yes.
• Notes: No changes are required.
Chapter 8 Getting Started with Base 257
Comentarios a estos manuales